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