Solved: Find unique values

[marshybid]

Hi All,

I have seen the answer to this before, but I can't find it.

I have one column of data (A) and I want to place a formula in the next column (B) that will only place a value against each unique value in column A

Example

Column A Column B
Apples 1
Bananas 1
Apples
Bananas
Pears 1

Hope this makes sense.

Thanks,

Marshybid

[Bob Phillips]

=IF(COUNTIF($A$1:$A1,$A1)=1,1,"")

[marshybid]

=IF(COUNTIF($A$1:$A1,$A1)=1,1,"")
Perfect xld, I had the formula the worng way round and was pulling my hair out:banghead: Have added this as array formula and copied down, works great.

I had =IF(COUNTIF($A1:$A$1,$A$1)=1,1,"")

No wonder it wasn't working!!!!

Marking as solved

Marshybid:hi:

[Bob Phillips]

It is not an array formula!