Hey Discussion Group,

Is there a formula that can find a cell reference corresponding to the row
of another column that is undergoing a transition?

For example:

Column A Column B
2
2
2
2
3
3
3
4
4
4 Need macro here

The macro that I am looking for returns a cell reference (ie B4, B7)
corresponding to the row when column A increases by one.

Thanks a lot!