# Using MATCH with a table

1. ## Using MATCH with a table

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

2. ## Re: Using MATCH with a table

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

3. ## Re: Using MATCH with a table

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) ?

4. ## Re: Using MATCH with a table

Yes,

Still an array formula

=MIN(IF(A1:E5=MAX(A1:E5),ROW(A1:E5),""))-MIN(ROW(A1:E5))+1

5. ## Re: Using MATCH with a table

Wrks grate Sweep - Many Thx

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1