Need help

[Need help with sumif]

A B
1 WOW
2 WOW
3 HOW
4 HOW
5 BOW
6 BOW

I want column B to write column A in order but no duplicate

Hi

Try something like this:
=IF(COUNTIF(A$1:A1,A1)=1,A1,"")
and fill down.

Hope this helps.
Andy.

"Need help with sumif" <[email protected]> wrote
in message news:[email protected]...
> A B
> 1 WOW
> 2 WOW
> 3 HOW
> 4 HOW
> 5 BOW
> 6 BOW
>
> I want column B to write column A in order but no duplicate