Correction

I said I would confuse myself and everyone else and I just did. ;)

Sorry, I want to take out "regardless of whether I create a list or not" from my last post. If I create a list, the system will insert "column x" to indicate a heading. Then it won't treat the first real name as a header. Problem solved.

Now, I am beginning to think that I didn't get the true picture on August 18. Biff, if you don't mind, can you comment on that thread please. I need a perfectionist like you to guide me. I can truly appreciate Bob's compliment (with love and grace) of you. ;)

Epinn

"Epinn" wrote in message ...
I think Biff might have saved my day.

Biff, have you read my experiment on an UNSORTED column (no list created) based on Dave's question? Can you confirm that regardless of whether I create a list or not, whether I sort the list or not, the data in the first selected cell will always be treated as a header? So, there is no bug afterall.

This is my impression based on my experiments and Biff's comments.

Thank you for your attention

Epinn

"Biff" wrote in message ...
If you sorted the list and the first and second entries were duplicates,
Excel considered the first entry as the column header when you used the
filter.

Biff

"Epinn" wrote in message
...
Hi,

Today's discovery:-

I have a *column* of first names, some of which are duplicates. I did a
sort and then I tried to do advanced filter and I ticked unique records.
The info generated was not 100% correct - one name showed up *twice*. In
other words, I didn't get a list of *unique* names. But it was interesting
that only ONE name (i.e. the first duplicate) didn't work.

I had a feeling that I should create a list but I wanted to see what would
happen if I didn't. Anyway, I backtracked and I created a list (without
header) and everything worked fine.

Lesson learned: Must always follow the rule to create a list (list create
list) before filtering. We can skip sorting but not creating a list. The
results will still be okay if data NOT sorted. However, it may speed up
processing if sorted??

Please feel free to comment.

Epinn