View Single Post
  #1   Report Post  
Saadi
 
Posts: n/a
Default How to find top five States?

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