something like this maybe pasted down for the entire range? it should show
the number of the occurance for each cell

=COUNTIF(N3:$N$3,N3)

"Ken" wrote:

Excel2003 ...

Range N3:N5002 ... contains 4 char Text (0200, 0340, 1050, etc) each value
repeats 50 times.

In Col D ... I wish a formula to return 1st occs only of each Value found in
Col N

== I can get results using "Advanced Filter Unique Records", but I need to
do this by formula (if I can?)

Thanks ... Kha