Thread: Find range of group & return highest value

Hi,

My spreadsheet is set up like this:
Test.xls


What I want to do is to find the highest temperature and pressure in each group, and copy this over to the green fields.
Is it also possible to copy the lowest and highest, so the result would be like "Min-Max" (60-90)?

I've tried using VLOOKUP where the range was found using ADDRESS but I couldn't get it to work.

Thanks in advance!!

Try this in I5:

=MAX(IF($A$2:$A$14=$H5,C$2:C$14))

Confirmed by Ctrl-Shift-Enter rather than Enter only.
Copy down and across

For MIN-MAX in same cell:

=MIN(IF($A$2:$A$14=$H5,C$2:C$14))&"-"&MAX(IF($A$2:$A$14=$H5,C$2:C$14))

CSE

=MAX(IF($A$2:$A$14=$H5,C$2:C$14)) copied across and down

committed with Ctrl-Shift-Enter rather than just Enter

Regards, TMS

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save