If Unique Formula

[pauldaddyadams]

Hi

Annoyingly I have lost the formula which I had to do this.

I have a list and I would like a formula which would enter a “1” for each unique entry in the list

Can anyone help please?

I have up uploaded an example.

Paul

[xlnitwit]

Hi,

Here is just one way

=IF(COUNTIF(D$5:D5,D5)=1,1,"")

[pauldaddyadams]

Thank you!