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" wrote
in message ...
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