Hi Tina If the grouping interval is consistent (100) then what Mynda suggest will work for you. But you mentioned 1-100, 101-500 (different inte...
Hi Tina The grouping interval in Pivot Table must be the same, i.e. 0-100, 101-200, 201-300 (interval of 100, for example) etc. I would suggest ...
Hi Daniel Suggest you use a pivot table to group the data then use a VLOOKUP to look for the date and the total cost. Hope this helps. Sunny
Hi Nazrin Give this a try. No idea how it will perform on 500 sheets as it uses a lot of INDIRECT functions. Good luck. Sunny
Hi Mahesh You can check this article to see if it helps somewhat. Don't think it will work on PivotTable though. Sunny
Hi Jake Thanks for your feedback. Glad to know that it helps. Sunny.
Hi Youri I suspect it is the single quotes in your formula. =IF('DASHBOARD!A6="","",’DASHBOARD!A6) If not, then please attach a sample for...
Hi Vic Try this. In cell B4 by enter =VLOOKUP("*",B5:B19,1,FALSE) Hope this helps. Sunny
Hi Terry If you double-click on the Sum of % of grand total header of the PT (or right-click the PT and select Value Field Settings), under the Sho...
Hi terry I don't have that issue (refer attachment) Please create the bar chart using the above data and attach your workbook so that we can hav...
Hi Andrea Possible to supply some sample data and your expected result? Sunny
Hi Chris See if this formula solution helps. Sunny
Hi Mark You could also use a formula instead. In cell C2 enter =IF(A2="c",1,IF(C1<>0,IF(C1<>4,C1+1,0),0)) You can then filter out...
Hi Nathalie You could try using a Pivot Table. Refer example attached.
Hi Charles There is no attachment.