Find the Max of s Subset within a Subset

[RINCONPAUL]

I have columns of subsets in col B. Within each subset, there are like values with "-L" added. I want a formula in col C that identifies these cells, within each subset, and finds the Max value in col A.

Thanks heaps for reading this.

[Bob Phillips]

You could try this array formula

=MAX(IF($B$2:$B$20=B2,$C$2:$C$20))

[RINCONPAUL]

Thankyou your Lordship, works a treat. Case closed.

Well done :)