Hello,
I have a table of numbers of, say 5 columns by 5 rows, located anywhere in a sheet.
I need to find the table row number containing the largest value in the table
Thanks for any help
Last edited by Pepe Le Mokko; 02-13-2012 at 06:46 AM.
Cheers - THE WARNING I RECEIVED WAS NOT JUSTIFIED
Hi,
This array formula should give you the required info:
=MIN(IF(A1:E5=MAX(A1:E5),ROW(A1:E5),""))
confirm with CTRL,SHIFT and ENTER
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Thanks for the formula Sweep
Can it be adapted to return the table's row number , f.i. E11:I16 and give the row number in that table (from 1 to 5) ?
Cheers - THE WARNING I RECEIVED WAS NOT JUSTIFIED
Yes,
Still an array formula
=MIN(IF(A1:E5=MAX(A1:E5),ROW(A1:E5),""))-MIN(ROW(A1:E5))+1
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Wrks grate Sweep - Many Thx
Cheers - THE WARNING I RECEIVED WAS NOT JUSTIFIED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks