BUMP
Hello guys and gals,
I need help finding a max value and then returning the sheet name where the max value resides. The max value resides in C177 on 17 different sheets. Here is the formula I am using: =MAX('Press 1:Press 24'!C$177). This obviously works to return max value, but I need to now return the name OR names of the sheets that contain this max number. Another way that might work is not returning sheet name(which is the press #), but returning the press number from cell A4 on each sheet. Also have to contend with multiple sheets that may contain the max number, so I need to return all the press numbers that are tied for max number. Any Ideas?
Bookmarks