Hi,
I'm trying to create a winners grid from 8 tables where I want to find the cell with the max %.
I can get the max cell function to give me the value of the max cell using the below code but I've been unable to work out how to get it to reference which cell its coming from possibly because they aren't in sequential columns:
=MAX(
'Q1'!B54,
'Q1'!O54,
'Q1 '!AB54,
'Q1 '!AO54,
'Q1 '!BB54,
'Q1 '!BO54,
'Q1 '!CB54,
'Q1 '!CO54)
Anyone else managed to do something similar to this?
Thanks
You'd have to do a MATCH to find where it's located (assuming the MAX value is unique)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try
Formula:
=max('Q1'!B54,Q1'!O54,Q1 '!AB54,etc.......)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks