I have 24 sheets name Press1 through Press24. I used the MAX fuction to find the highest number from cell C177 across all sheets. What I need to do is produce the name of the sheet OR press number from cell A4 (name is in the same place on each sheet) where the highest number resides. This is the formula I used to get the highest number, but can't figure how to get name where it came from. Tried a combination of INDEX & MATCH but to no avail. Any ideas???
=MAX('Press 1:Press 24'!C$177)
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread. http://www.excelforum.com/excel-gene...max-value.html
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks