What's the OR for?

It's doing nothing!

Nevermind, I see!

Biff

"Biff" wrote in message
...
What's the OR for?

It's doing nothing!

Biff

"Domenic" wrote in message
...
Assuming that A1:A10 contains your data, try the following...

B1: Leave empty

B2, copied down:

=IF(OR(COUNTIF($B$1:B1,A1:$A$10)=0),INDEX(A1:$A$10 ,MATCH(0,COUNTIF($B$1:B
1,A1:$A$10),0)),"")

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Peter" wrote:

I want to extract the unique records from column A into column B by
formula
ie: NOT using the Advanced Filter. Any ideas? Thanks.