Extracting name of sheet having maximum value in a particular cell

[Sg_89]

Hi,

I am using the following formula to get maximum value from a particular cell across 97 different sheets with name variation. This works fine. How can I get the sheet name from which the maximum value is coming?
Best, Sushant

=MAX(MAX('LK1 - 4.1 Stäbe - Schnittgrößen:LK9 - 4.1 Stäbe - Schnittgrößen'!Q10),MAX('LK10 - 4.1 Stäbe - Schnittgröße:LK97 - 4.1 Stäbe - Schnittgröße'!Q10))

 

[pgc01]

Hi
Welcome to the board

One option is a a formula solution. You write the names of the worksheets in a range and to a match.
Another option is vba. If you use vba, write some code to loop through the worksheets and find the value.

Remark: why 2 Max's inside the outer Max? Are the worksheets not contiguous?

 

[Sg_89]

Hi ,

Thanks for replying. I found the answer here-
http://www.mrexcel.com/forum/excel-questions/212247-return-sheet-name-containing-max-value.html

See the comment by Domenic.

Best regards