PDA

View Full Version : Solved: Find unique values



marshybid
07-02-2008, 02:39 AM
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
07-02-2008, 02:50 AM
=IF(COUNTIF($A$1:$A1,$A1)=1,1,"")

marshybid
07-02-2008, 02:54 AM
=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
07-02-2008, 03:10 AM
It is not an array formula!