Search:

Type: Posts; User: LalitPandey87

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    1,804

    The values you have shows are in date format or...

    The values you have shows are in date format or text format?
  2. HDWallpapers.in automation to download images automatically

    Usually i spend time to download HD wallpaper for my laptop screen and generally i download it form HD Wallpapers (High Definition) | 100% Quality HD Desktop Wallpapers site. This site has a very...
  3. You can take help from...

    You can take help from
    https://support.office.com/en-us/article/Drill-into-PivotTable-data-c1b11240-fc8f-4fdd-a697-629bf6f7ee0b
    Excel Pivot Table DrillDown
  4. Could you please attach your file for better...

    Could you please attach your file for better clarity.
  5. You can not delete any sheet without opening...

    You can not delete any sheet without opening excel file. In your case what you can do is open each file pragmatically using VBA delete the sheet then save and close the workbook.
  6. Can you show the sample with different...

    Can you show the sample with different formatting. It helps to understand your problem well.
  7. Try this: Enum OL_Info ...

    Try this:



    Enum OL_Info

    CompanyName = 1
    BusinessAddress = 2
    BusinessAddressCity = 3
    BusinessAddressState = 4
  8. Replies
    5
    Views
    1,650

    You just need to change the number format that's...

    You just need to change the number format that's it. As i can see there is a custom format h:mm applied on the range just change it to general. Check attached file.

    1767
  9. Not clear. :confused: Please provide additional...

    Not clear. :confused:
    Please provide additional information.
  10. Replies
    5
    Views
    1,856

    In the file, you have attached, in I sheet column...

    In the file, you have attached, in I sheet column c is not available thats it.:confused:
  11. Add dropdown in the sheet and select data as the...

    Add dropdown in the sheet and select data as the source of drop down and select value based on the selection and position you will get the value that's it.
  12. In your example you have used a drop down and...

    In your example you have used a drop down and based on selection you know the row no of selected value even if it is repeated or not but in case of formula how would excel know which number of...
  13. Yes Transformer you are right. Another way of...

    Yes Transformer you are right. Another way of doing it. :):cool:
  14. You can add button in every slide whenever you...

    You can add button in every slide whenever you add a new slide as below:

    First open VBA editor and add Class Modules and Copy & Paste below code. This is a class module and contains event of...
  15. Attach sample file please.

    Attach sample file please.
  16. Not understable could you please make it more...

    Not understable could you please make it more clear with steps.
    And do not share your password in public formus you can just provide the explanation here and if you find some one who is going to...
  17. You can not append a new blank field in the same...

    You can not append a new blank field in the same recordset but there is a workaround for this:


    First get all data in one recordset which is Recordset1
    Then create a new recordset Recordset2...
  18. In your code there are two email sending code...

    In your code there are two email sending code first one is for Sheet1 or Sheet2 and second is for Sheet9 or Sheet2 so what email sending code you want me to check.

    Or check this one and add red...
  19. Cool :cool:

    Cool :cool:
  20. Replies
    4
    Views
    1,197

    Hi In J3 with Ctrl + Shift + Enter ...

    Hi

    In J3 with Ctrl + Shift + Enter

    =SUMIF(OFFSET($D$2,0,0,1,MAX(IF($D$2:$IV$2 = $D$2, COLUMN($D$2:$IV$2 ),0))-2),$D$2,OFFSET($D$2,ROWS($J$3:$J3),0,1,MAX(IF($D$2:$IV$2 = $D$2, COLUMN($D$2:$IV$2...
  21. Replies
    14
    Views
    3,871

    Although the solution which i provided you is...

    Although the solution which i provided you is perfectly working for me, i think the only issue is you are not familiar with array formula so you can google it.
    Here i am posting a new solution based...
  22. Replies
    14
    Views
    3,871

    All formulas are array formula so what is missing...

    All formulas are array formula so what is missing in your file is:

    First select the range A3:A17 Press F2 and then Ctrl + Shift + Enter

    Try this and it will solve your problem.
  23. Could you please share your file?

    Could you please share your file?
  24. Replies
    1
    Views
    836

    Could you please attach sample file and make your...

    Could you please attach sample file and make your query more understandable so may be someone would help you. :confused::confused::confused:
  25. Replies
    14
    Views
    3,871

    Try this: For Current Year Table (Change Total...

    Try this:

    For Current Year Table (Change Total Mark Column header to Total Marks)

    Step 1:
    In Cell A3 put below formula and Press enter then select A3:A17 and press Ctrl + Shift + Enter:


    ...
Results 1 to 25 of 221
Page 1 of 9 1 2 3 4