Finding the highest value across worksheets and returning the worksheet name
I have a workbook containing 13 worksheets - 12 worksheets containing the monthly sales figures which are named January through to December and 1 worksheet to summarise the annual figures.
I am trying to find the highest value in cell C14 across all 12 monthly worksheets and then display the worksheet name as the result....is this possible?
I am also trying to do exactly the same as the above but display the actual figure of the highest amount rather than the worksheet name.
Any advice on these two issues would be very much appreciated.
Thanks in advance.
I'm not sure how to get the worksheet name, but to get the highest amount, you could try something like this
If you sheets have long "month names" modify to suit.
Try listing your worksheets in column A starting with cell A2:A13.
This formula below will return the worksheet name. Input formula in cell C2.
The formula is an-arrays need to hold down:
Example workbook below.
Last edited by vane0326; 04-30-2007 at 10:30 PM.
Excellent thank you!
I've modified these slightly and they work perfectly.
Thanks for the starting point.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1