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
 
Top