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
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