Finding first instance of a value

[goldenclick]

Is there an easy way to find if a value is the first instance in a set? For example...

A
A
A
B
C
C

For value one I want to see if it is the first value in the range of all A's, if so do something otherwise do something else. Then for value 2 the same thing...

[ConneXionLost]

Hi,

How about like this?

Cheers,

[goldenclick]

That works, thanks.

=IF(COUNTIF($A$2:A11,A11)=1,"Do something","Do something else")

Just to clarify, this says:

If the count of A11 is 1 in the range A2:A11 then do something, otherwise do something else.

[Miraun]

Correct, it's counting all values up until the current row. So if it's the first instance of it, the count will result in 1. With the If statement, if it is 1, you can "Do something", if it is not one, it is the repeat, you can "Do something else"

You can use the formula =COUNTIF($A$2:A11,A11) to determine which it is (if you just want to see the 1/2 count rather than performing the next equation, just as a quick sanity check.