With a Custom AutoFilter, you can only enter two criteria. I previously
suggested adding a column to your table, and filtering on that column.
Did you try that?

custom autofilter in excel wrote:
thank u so much for the info
but what i really wanted is just a simple way to filter out my desired
values, is being put in which row, that is all, i do not want to create
another table for this, for e.g. just show the rows that has the values
'abc', 'ghi' and 'mno'. Is there any other simpler way to achieve this?

"Debra Dalgleish" wrote:


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





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