Excel function or simple VBA question: I need to search lists of
numbers to find the missing numbers and insert these numbers. It is
for telephone extension lists to find what extensions are not being
used. Eg 2200 through 2399 may have 50 numbers not in use. I currently
can use the VLOOKUP fcn nested in the ISNA fcn, then i have to filter
the false/true, copy the results - and i still don't have a single
list. Is there a function that can do this or only vba? thanks

---

Request for Question Clarification by mathtalk-ga on 29 Oct 2004 22:18 PDT

Hi, ambersdad-ga:

Can we assume the range of available numbers is consecutive, as in
your illustration of 2200 through 2399?

regards, mathtalk-ga

---

Request for Question Clarification by endo-ga on 30 Oct 2004 11:26 PDT

Hi,

Can you provide a sample Excel file please?

Thanks.
endo

---

Clarification of Question by ambersdad-ga on 30 Oct 2004 12:02 PDT

To Mathtalk - yes, the numbers would be consecutive. I have ranges
that are always 3 or 4 digits long since they are extension ranges for
companies. So an example would be a list of 200 numbers from 600-799,
or two ranges 600-699 and 800-899. Sometimes the ranges are bigger
such as 2200 - 2699. I don't know how to post a sample excel file but
the range of numbers is so simple one can create a sample in just a
few seconds. The key issue is that i am always missing numbers and
need to easily find the missing numbers and insert them in a simple
quick way. Hope this helps.

---

Request for Question Clarification by endo-ga on 30 Oct 2004 12:21 PDT

Hi,

If you can upload a file to the following FTP, I can write a macro
that will fit your file correctly.

host: ftp.membres.lycos.fr
username: dbky
password: googleanswers

Thanks.
endo

---

Clarification of Question by ambersdad-ga on 30 Oct 2004 13:29 PDT

tried to log into FTP site but no luck - entered password and user
name but it took too long and timed out. Should i try later.

---

Request for Question Clarification by endo-ga on 30 Oct 2004 13:44 PDT

Hi,

Yes please. You can try this URL directly in your browser.

ftp://dbky:googleanswers@ftp.membres.lycos.fr

Thanks.
endo

Hi, endo-ga:

If I may make a suggestion, perhaps it would be simpler if you were to
pursue this by creating your own sample spreadsheet.  It may be easier
for Readers to download a solution that you place on your website than
to upload materials there.

regards, mathtalk-ga