Try...

A2, copied down:

=IF(COUNTIF($B$2:B2,B2)=1,"Y","")

Hope this helps!

In article ,
"PH NEWS" wrote:

Thanks, but that's not really what I'm looking for. I'll try to explain
further. In B2:B20 I have a list like so
1
1
1
2
2
2
2
3
3
4
4
and so on. In column A, I'd like a value to appear next to the first
occurrence of a number, so A2 would say "Y" and then the next "Y" would
appear next to the first 2 and so on. Is that possible?