puzzling auto filter problem

jtheat

New Member
Joined
Sep 28, 2006
Messages
4
A friend has a database that includes a row of 7000 customer names. When the auto filter for that row is selected, it show all of the names but one. I have done all of the obvious things to solve this but with no luck.

When I sort the data alphabetically, The name will show up in autofilter. When I sort it back to the previous listing, the name disappears from the auto filter list. I have been using excel and visual basics, etc. for years and this is the first time I have been stumped. I usually bulldog until I solve problem, but this one has me scratching my head.

Any ideas?

Thanks from a first time poster.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi jtheat
Welcome to the board

When you say "The name will show up in autofilter" you mean it shows in the dropdown arrow of the autofilter?

Just a thought...

How many different names have you got in the column? I believe the maximum number of items in the dropdown arrow of the autofilter is about 1000.

Hope this helps
PGC
 

Forum statistics

Threads
1,141,587
Messages
5,707,252
Members
421,498
Latest member
matinebi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top