View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Helper Formula To Identify 1st Instance of a Value

=COUNTIF($A$1:A1,A1)=1

adapt to your own data and copy down in an adjacent cell will return TRUE
for 1st occurrence

--

Regards,

Peo Sjoblom

"carl" wrote in message
...
I have a series of data like this.

InternalSubcriberRef
30564.00
22222.99
22222.92
30564.00
30564.00
30564.00
30564.00
30564.00
30564.00
30564.00

Would like to add a helper column that will flag the 1st instance of a

given
value.

Thank you in advance.