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

On Fri, 6 Oct 2006 09:34:02 -0700, Jean wrote:

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.