Numbers NOT in my spreadsheet

G

gary

A1 thru A500000 contains numbers from 0500006986 to 0510030406

I need to know which numbers do NOT exist.

How can I do that?
 
G

gary

Yes, the numbers are sorted.

Here are the results:

0500006986
0500007037 51
0500007246 209
0500007488 242
0500007509 21
0500007664 155
0500007675 11
0500007763 88
0500007873 110
0500007884 11
0500008090 206

But I need the missing numbers; for example:

0500006987
0500006988
0500006989
0500006990
0500006991
0500006992
etc

not the count of the missing numbers
 
I

isabelle

hi gary,

this is real numbers or were formatted as number (0000000000) or there
are a text format?

isabelle

Le 2013-02-27 14:48, gary a écrit :
 
G

GS

gary brought next idea :
A1 thru A500000 contains numbers from 0500006986 to 0510030406

I need to know which numbers do NOT exist.

How can I do that?
Click to expand...

See my reply in your post to the Programming forum...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

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

How to count the numbers in a Word document? 0
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Removing Line Numbers 4
Setting column width in a table with a macro is not working 0
Centered text that does not stay centered 0
Creating Different Headers in Word 0
Text duplication question 0

Top