Re: Top 5 values with corresponding data containing identical values
Hi Beaczar,
I'm not sure this what you are looking for, If not maybe someone else can help you out.
In cell G1 input max value 5
H2,
=COUNTIF(B2:B26,">="&LARGE(B2:B26,G1))
I2, copied down:
=IF(ROWS(I$2:I2)<=$H$2,LARGE($B$2:$B$26,ROWS(I$2:I2)),"")
J2, confirmed with CONTROL+SHIFT+ENTER, and copied down:
=IF(I2<>"",INDEX($A$2:$A$26,SMALL(IF($B$2:$B$26=I2,ROW($B$2:$B$26)-ROW($B$2)+1),COUNTIF($I$2:I2,I2))),"")
I uploaded a sample file for you.