Find missing entries from a list of sequential numbers and letters in a column?

I have an Excel sheet containing the names of 3000 PCs in

PC-No0001
PC-No0002
PC-No0003
PC-No0004
PC-No0006
PC-No0007

in column C

How can I find easily the missing name in the above example PC-No0005

Thanks

Assuming your list is in column A, enter the formula below and array confirm it with Shift Ctrl Enter, then use the fill handle to copy it down until it returns a blank cell.

Formula:

Please Login or Register  to view this content.

Thanks Alot

---------- Post added at 12:34 PM ---------- Previous post was at 12:33 PM ----------

Originally Posted by zbor

Here, try this:

Formula:

Please Login or Register  to view this content.

Thanks Alot, works!

@ ramim

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.