Domenic,

I have tried but can't do it. can you please make it in a Excel sheet and
send it over. my mail id is

I shall be very thankful to you for this favor.

Saadi

"Domenic" wrote:

Try the following approach, which will take into consideration ties for
5th place...

Assumption:

1) Column A contains your list

2) Your data starts in the second row

Formulas:

B2, copied down:

=IF(ISNA(MATCH(A2,$A$1:A1,0)),COUNTIF($A$2:$A$13,A 2),"")

C2, copied down:

D1: enter 5 (indicating you want a Top 5 list)

E1:

=MAX(IF(B2:B13=INDEX(B2:B13,MATCH(D1,C2:C13,0)),C2 :C13))-D1

....confirmed with CONTROL+SHIFT+ENTER

F2, copied down:

=IF(ROW()-ROW($F$2)+1<=$D$1+$E$1,INDEX($A$2:$A$13,MATCH(ROW( )-ROW($F$2)+1
,$C$2:$C$13,0)),"")

If you want a Top 10 list, Top 20 list, etc., change the number in D1 to
the desired number.

Hope this helps!

In article ,
"Saadi" wrote:

hi,
I have a problem in my records sheet. I have a field named "STATES", and the
task is to find out the top five states in it. Like the most repeated states
upto 5 levels. the Sample data is like,

MO
LA
LA
LA
MO
MO
MN
IL
FL
IA
MA
AK

Can anyone help me out to get rid of this problem. I am doing this manually
which is so difficult for me.

Thanks,
Saadi