Helper Formula To Identify 1st Instance of a Value
 

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.

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.

Helper Formula To Identify 1st Instance of a Value
 

Try this:
If your list begins in Cell A2
B2: =IF(COUNTIF($A$2:A2,A2)=1,"First","")
copy that formula down as far as you need.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"carl" wrote:

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.