I have this formula =INDEX($A$3:$A$11,0,MATCH(MAX($P3:$P11),$P3:$P11,0)) thats supposed to return the name of the person with the highest average fuel consumption and i dont what it is,but i seem to get the REF error.heres a image showing you thatABCD.png
=INDEX($A$3:$A$11,0,MATCH(MAX($P3:$P11),$P3:$P11,0))
Row ZERO ?
You cant have a row zero, surely?
Which also suggests your MATCH is looking across columns.
Swap them round then change the 0 to 1.
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.
Formula:
Please Login or Register to view this content.
you are checking in which ROW, so put result as ROW parameter not column.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks