Sort / Rank as per maximum to minimum count

Originally Posted by thilag

Hello Azumi

thanks for the formula

<=IFERROR(INDEX($A$1:$A$100,MODE(IF(($A$1:$A$100<>"")*1*ISNA(MATCH($A$1:$A$100, D$1:D1,0)),MATCH($A$1:$A$100,$A$1:$A$100,0)*{1\1}))), "")>

but the attached file shows the error message when using your formula. I thing there may be some error in 1/1 area.


Other formauls workng well thanks.

thilag.

yes sorry about the error, maybe coz my indonesian system, just check the file