Hi JKL,

This may help you (or not).<g
Select your data in Col. A and goto DataFilterAdvanced Filter,
Check 'Copy to another Location'
Check 'Unique Records Only'
Select a destination cell in the Copy to box
And OK out.

HTH
Martin