Name of the sheet where the formula result is

C

catherine

I use max()and min() in the result sheet to define the max
and min values in 10 sheets where test data are. How can I
display the sheet name of the result from the
calculations? For example, if the result of max() is from
sheet 1?

Thanks a lot
Catherine
 
B

BrianB

You will probably need a macro to search the sheets for the values. I
would probably be a good idea to keep searching to the end of the las
sheet to check for duplicates
 
D

Dave Peterson

This might not work for you, but I'd lay out part of my summary sheet like:

Sheetname Max (this formula)
Sheet1 =MAX(INDIRECT("'" & A2 &"'!a1:iv65536"))
sheet2
....
sheet10


SheetNames in A maximums in B, and minimums in C.

Then to get the name of the worksheet with the (first) largest value:
=INDEX(A2:A11,MATCH(MAX(B2:B11),B2:B11,0))
 
Top