You could use a pivot table to summarize the data. Add the column with
letter values to the row area, and another copy of the column to the
data area, where it will appear as Count of value.

There are pivot table instructions and links he

http://www.contextures.com/xlPivot01.html

custom autofilter in excel wrote:
thanks all for the replies but what i meant is , for e.g.
i have 1 column with values, 'abc', 'def', 'ghi', 'jkl' and 'mno' in
multiple rows but in ONE column and then i wanted to find out how many rows
do, for e.g. 'abc', 'ghi' and 'mno' has occupied, is it possible?
please let me know the steps n if it is possible in excel......

"custom autofilter in excel" wrote:


i need to filter multiple values (more than two, they are alphabets) in ONE
column ONLY in Custom AutoFilter.
Please help soon.
thanks.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html