Try Data / Filter / Advanced Filter / 'Copy to another location' & 'Unique
values only'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Need help with sumif" wrote
in message ...
A B
1 WOW WOW
2 WOW HOW
3 HOW BOW
4 HOW
5 BOW
6 BOW

I want column B to write what ever is on column A with No duplicates Just
like what I wrote on column B