Same s.no but length is different want to highlight maxs length of Same serial no in excel

enter image description here

A column contains S.no, B column contains Length, In c column i want maximum length in b column which is having same serial no.
For eg:

enter image description here

>Solution :

You could try the following formula:

enter image description here

• Formula used in cell C2

=REPT("MAX",MAX(($A$2:$A$16=A2)*$B$2:$B$16)=B2)

Or, if you want to display the max number for each sl.no then

enter image description here

• Formula used in cell C2

=REPT(B2,MAX(($A$2:$A$16=A2)*$B$2:$B$16)=B2)

Leave a Reply