Breas in Sequencing

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

April 17th, 2015 10:29am

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

Free Windows Admin Tool Kit Click here and download it now
April 20th, 2015 2:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics