Hi,

I got a problem with "Autofilter" in Excel 2002.

After clicking Data > Filter > AutoFilter, all fields header appears as dropdown to allow selection.

There are 2 fields involved:
1. Column "Name"
2. Column "Company"

While every dropdown is in (ALL), I could not find the person's name in the dropdown at column "Name".

But while I select a certain company name in column "Company", then I could find the person's name in the dropdown at column "Name".

Seems like a hide and seek for me.

Cheers.....