custom autofilter in excel

[Guest]

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

 

[joytickle]

see the website http://www.contextures.com/tiptech.html about the tips
on advanced filter
"custom autofilter in excel дµÀ£º
"

 

[Debra Dalgleish]

Another option is to add a column to your table, and check for the
values in a list. Then filter the new column for TRUE.

For example, list the values in cell M1:M5
In the new column of the table, in row 2, enter the formula:
=COUNTIF($M$1:$M$10,E2)>0
Copy the formula to the last row of data
Filter that column for TRUE

 

[Guest]

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......

 

[Debra Dalgleish]

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 here:

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

 

[Guest]

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]

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?

 

[Guest]

i do not need the COUNT(how many times the value is re-curring) instead i
need it to display rows of values (on which row specifically) for e.g. if
'abc' is on row 1 and 3, 'def' is on row 2 and 4, and 'ghi' is on row 6, so
when i query for values 'abc','def' and 'ghi', it will appear the rows :
1,2,3,4 and 6 with data in it

 

[Debra Dalgleish]

In the CountIf example that I posted earlier, the count is used to
determine if the value in that row exists in your list of criteria. So,
if row 3 contains abc, and that value is in the list of criteria, the
formula will return a TRUE. If abc were not in the list of criteria, the
formula would return a FALSE. When you filter that column for TRUE, rows
that contains values from the criteria list would appear, and other rows
would be hidden.

 

[Guest]

Thank u very much on that but what i meant is, what if i want to know more
than 'abc' like 'def' and 'jkl' as well....is it posibble in excel?