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