The values you have shows are in date format or text format?
Type: Posts; User: LalitPandey87
The values you have shows are in date format or text format?
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...
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
Could you please attach your file for better clarity.
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.
Can you show the sample with different formatting. It helps to understand your problem well.
Try this:
Enum OL_Info
CompanyName = 1
BusinessAddress = 2
BusinessAddressCity = 3
BusinessAddressState = 4
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
Not clear. :confused:
Please provide additional information.
In the file, you have attached, in I sheet column c is not available thats it.:confused:
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.
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...
Yes Transformer you are right. Another way of doing it. :):cool:
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
...
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...
Attach sample file please.
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...
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...
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...
Cool :cool:
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...
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...
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.
Could you please share your file?
Could you please attach sample file and make your query more understandable so may be someone would help you. :confused::confused::confused:
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:
...