I have a column with data starting with A01, then A02, A03, A04 and so on. However the info is not always consistent, it might jump from A05 to A09. I want to know if there is a formula that lets me know if the cell above has gotten bigger by 1.
example
A01
A02
A05, not consistent
A06
Thanks
example
A01
A02
A05, not consistent
A06
Thanks