Hi All,

I'm in need for a formula which will return the reference of a cell when the value in another cell changes.

Example:

A B
1
1
1
1
2 reference to B5 is needed to be returned as the value in A5 changed from 1 to 2
2
2
8 reference to B8 is needed to be returned as the value in A8 changed from 2 to 8
8


Can I get some help with this request please?

Many thanks.

T.