Hi,
I have a set of data that looks like this:
<tbody>
</tbody>
In another sheet I have the list of names but not in the same order (there is a reason for that). I want a formula that will look for the Name in column A and then return the largest number for that name in columns B:F.
For example:
Forumula looks at the name sees E and returns 26.
I've tried looking at HLOOKUP, MATCH and INDEX but can't find a way of looking at the range based on a specific criteria.
Any help greatly appreciated.
I have a set of data that looks like this:
Name | 1 | 2 | 3 | 4 | 5 |
A | 12 | 15 | 16 | 10 | 6 |
B | 6 | 4 | 15 | 1 | 19 |
C | 22 | 14 | 13 | 17 | 10 |
D | 6 | 8 | 7 | 10 | 6 |
E | 8 | 9 | 15 | 26 | 4 |
F | 10 | 14 | 19 | 2 | 10 |
G | 15 | 16 | 20 | 25 | 15 |
H | 16 | 20 | 22 | 10 | 8 |
I | 14 | 16 | 19 | 17 | 6 |
<tbody>
</tbody>
In another sheet I have the list of names but not in the same order (there is a reason for that). I want a formula that will look for the Name in column A and then return the largest number for that name in columns B:F.
For example:
Forumula looks at the name sees E and returns 26.
I've tried looking at HLOOKUP, MATCH and INDEX but can't find a way of looking at the range based on a specific criteria.
Any help greatly appreciated.