Chip Pearson has a good article on most common entry in list:

http://www.cpearson.com/excel/lists.htm#MostCommon

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Saadi" wrote in message
...
Hi guys, I am facing a problem to find out the maximum number of Text
Occurrence in a cloumn.

Suppose I have data in State filed like this in G Column

G
State
CA
CA
FL
GA
GA
CO
CA
FL
IL
FL
WA
FL

Now I want to Show top 3 states in column G30, and H30 automatically. e.g.

FL 4
CA 3
GA 2

so the problem is this how do I check the Max number of occurence of a
state
and print it and its number in respective cells.

thanks in advance,

Saddat Sarfraz
Saadi