Compare two cells with same name

  • Thread starter Thread starter Hamps hump
  • Start date Start date
H

Hamps hump

Hi,

I would like to Compare two cells with the same name ie. I1A215 and put "LP"
against the lower number but not compare two different names ie. IA219 with
IA227 as shown below.

I1A215 7567.16 LP
I1A215 9324.94
I1A219 5372.08 LP
I1A219 7127.87 LP
I1A227 7130.59 LP
I1A227 8307.19
I1A233 1983.48 LP
I1A233 3404.38

Thanks
 
You can use this array* formula, adjusting ranges as needed:

=IF(B1=MIN(IF($A$1:$A$8=A1,$B$1:$B$8)),"LP","")

*Confirm formula using Ctrl+Shift+Enter, not just enter.
 
Back
Top