I hope you understand my qwuestion

[Need help with sumif]

> 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

[Ken Wright]

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" <[email protected]> wrote
in message news:[email protected]...
>> 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

[Ron Rosenfeld]

On Wed, 25 Jan 2006 13:01:02 -0800, "Need help with sumif"
<[email protected]> 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