Missing words and numbers

[p206ab]

Hi!

I have a problem, I recieved a huge list of numbers on my email, and my boss said I have to put them in Microsoft Excel and find out which ones are missing. (list shown here:bit.ly/jflBZ8) File is attached below.

String contains one word and three numbers e.g. A582, U821,...

Anyone knows a function for this?

Thank you!
Best,

[johnjohns]

Please let us know how the sequence should be. Like whether it is A121,A122......A500, then B121,B122..
or can we discard the alphabet part and count only the numeric side?

[nazmul_muneer]

Provide some example as you want

[johnjohns]

Please see the attachment. With Data->Text to columns->Delimited with Comma, I have put the values in seperate cells. Then with Copy->Paste->Special->Values -Transpose copied them to in a single coulmn. In the sheet All Numbers I have given all the values and selecting them all and running the macro MissingOnes I have highlighted the missing values.

[p206ab]

Please see the attachment. With Data->Text to columns->Delimited with Comma, I have put the values in seperate cells. Then with Copy->Paste->Special->Values -Transpose copied them to in a single coulmn. In the sheet All Numbers I have given all the values and selecting them all and running the macro MissingOnes I have highlighted the missing values.

Thank you, thank you, thank you!!!!
This is exactly what I needed!
You just saved my job

[snb]

or:

Please Login or Register  to view this content.