Missing alphanumeric number in the sequence

S

Stephanie

hi, please help me here.
i just would like to know, is there a formula to detect a missing
alphanumeric number in a sequence?
Ex. if i have AA01, AA02, AA03.......AA100. how to detect of example AA03 is
missing?
please help...thanks!
 
J

Jacob Skaria

Try the below formula ..

'to check for sequence AA01 to AA05
=IF(SUMPRODUCT(--ISNA(MATCH("AA"&TEXT(ROW(A1:A5),"00"),A:A,0))),"Numbers
missing","No numbers missing")


'to check for sequence AA01 to AA10
=IF(SUMPRODUCT(--ISNA(MATCH("AA"&TEXT(ROW(A1:A10),"00"),A:A,0))),"Numbers
missing","No numbers missing")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Custom Number sequences 0
Adding sequence numbers to paragraphs 0
Missing items in the menu bar 1
Alphanumeric 22
How to Create an S-Curve from Custom Field? 0
filter column unique for alphanumeric 6
Mail Merge Switch - Dollars to Words 0

Top