My column does not always have Alphabet. It may contain words.

saman110 wrote:
I have a column with many rows that may have blank cells in between them. how
can I get the instance or count of them?

For example in A column I have;

Q
S
Q
Q
H
H
C

Results should be;

3 Q
1 S
2 H
1 C

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200803/1