I have a list in Excel that has serial numbers. I was wondering if there is any way to show when there is a break in the sequencing (eg. A123, A124, A125, A127 - show missing number A126).
Thx!
Ann LeBlanc
Technology Tips and News
I have a list in Excel that has serial numbers. I was wondering if there is any way to show when there is a break in the sequencing (eg. A123, A124, A125, A127 - show missing number A126).
Thx!
Ann LeBlanc
Hi Ann LeBlanc,
As you said, you want to show the missing number in your spreadsheet. I wonder to know how to show the missing number in the spreadsheet? Modify to the correct number directly, or you want to sign the missing number?
I can sign the missing number via using the IF function. With your sample, I sorted the numbers first. Then as shown in the figure, I got the result FALSE in column B with A127 when A126 in missing between A125 and A127.
I hope its helpful.
Please let us know if you need further assistance, Ill be glad to assist you.
Regards,
Emi