Advanced Filter

[Guest]

I need to use an Advanced Filter because my database is too long for
AutoFilter. What do I put in the criteria range to find the cells in a
particular column that END in the letter "n"? I tried using *n but my result
showed all names with the letter "n" in it. Thanks.

 

[Guest]

I'm sure there are shorter ways to do this, but try inserting a column, and
enter and copy down this formula: =RIGHT(A2) where A2 = the first cell of
the particular column you refered to. This will result in the last
(rightmost) letter of A2 - Annn. Then you can sort on that column to get all
cells that end in N. To be safe, copy your database and work with the copy!!

Carole O

 

[Gord Dibben]

Why do you think your database is too long for autofilter?

I run Excel 2003 and can autofilter on a column with 65536 entries.

Custom "ends with" "n" should do the trick with Autofilter.


Gord Dibben MS Excel MVP