Thread: Dectecting Changes in Excel

Hi guys, I'm quite new to excel so please forgive me if this question seems too straightforward.

Basically what I want to do is to scan through column X and detect changes.For rows that has no change, nothing happens. For rows that has changes, a value will appear in column Y. Here's an example:


X Y
A
A
A
B J
B
B
B
C J
C
C
D J
D

So basically I want all the first of each value marked. Can anyone help? I'm desperate. I'm dealing with 25,000 rows and have to do this manually.

Thanks a lot Andy! You just saved me HOURS.... a DAY!

But your formula currently displays "J" for the last row a particular variable, not the first row of a new variable. This can easily be fixed by adding a cell but do you think there's anyway to correct this?

Thanks again.

Thank you very much, Marcol. That works perfectly.

No problem

Andy has to sleep sometime!

If this resolves your problem. Please mark your post [Solved]