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
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 07:46 AM.
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
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
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) ?
Yes,
Still an array formula
=MIN(IF(A1:E5=MAX(A1:E5),ROW(A1:E5),""))-MIN(ROW(A1:E5))+1
Wrks grate Sweep - Many Thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks