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

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

On Wed, 25 Jan 2006 13:01:02 -0800, "Need help with sumif"
wrote:

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

1. Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

2. B1:

=INDEX(UNIQUEVALUES($A$1:$A$6,1),ROWS($1:1))

Copy/drag down as far as required.
--ron