the first selected cell will always be treated as a header?

Yes

Biff

"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