Adjusting Range based on values in one column

[LadyS]

Hi,

I am trying to adjust a range based on certain values in a given column. In this case, I have text values in Column A (A2:A15), and their number values in Column B (B2:B15). In column C, I would like to find the Max value of Column B for each unique text value range in Column A so in this case MAX(A2:A9) and MAX(A10:A15). I would also like to do this without VBA, naming ranges, and referencing a separate cell if possible. Just using a single formula that will adjust as I add in more unique samples in column A and B. I hope this isn't too confusing.

Capture4.JPG

[Olly]

Array formula (so Ctrl-Shift-Enter) in C2:

Please Login or Register  to view this content.

And copy down...

[LadyS]

Perfect! Thank you so much!!