RE: Adding numbers to an incomplete numerical list

OK....then maybe something like this would be easier to follow:

If your sequence is in A1:A11000
beginning with 1, but containing gaps
AND
it should contain values 1 through 12000

Then
C1: =IF(ISNA(MATCH(ROW(A1),$A$1:$A$11000,0)),ROW(A1),"delete")
Copy that formula down through C12000

(That should list the missing numbers and "delete")
Then....
Select C1:C12000
<edit><copy>
<edit><paste special>Check: Values

Then...sort C1:C12000, ascending

The missing numbers will appear at the top of the list....copy them to the
list.
Clear the "delete" cells.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"hana" wrote:

It is a complete series 1,2 3,4,5 to about 12,000. Do you have an easier way
to do it?
--
Hana


"dribler2" wrote:

Hi hana,
it depends on which passing criteria you need to base the numbers that must
be inserted as to be added....

is it a complete series...1,2,3,4 to forever
or 1,3,5,7,....all odd
or 2,4,6,8,....all even
or whatever jumping series you need to specify over here..

best regards,
dribler...
--
*****
birds of the same feather flock together..



"hana" wrote:

I have a list of numbers w/ data that doesn't include all of the numbers. I
need to add numbers to the list to complete the numerical list (so the added
numbers would have no data in the row, just the number). It seems like such
a simple thing to do and yet I have no idea how to actually do it. Does
anyone know something that would help me to complete this list?
--
Hana
.