Name of the sheet where the formula result is

  • Thread starter Thread starter catherine
  • Start date Start date
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
 
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
 
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))
 
Back
Top