RE: Adding numbers to an incomplete numerical list

Wow! That formula is a lot easier to understand than the other one.
However, a brilliant co-worker of mine understood your original formula
better than me and he got it to work as well. So now I have more than one
way to do this. I am set as long as I never lose these formulas.

I have to say that I am completely amazed by your knowledge of excel. Did
you understand and create these formulas off the top of your head? I am just
amazed. I didn't know that I knew so little about excel until I got your
assistance.

Thank you so much. It has been very useful.
--
Hana


"Ron Coderre" wrote:

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
.

Relevant Pages

  • Re: Compile Error in Hidden Module: Main Module
    ... Missing VBE libraries ... I've copied the other reported usual suspects for yr convenience below. ... Office 97 when it comes to Excel VBA issues. ...
    (microsoft.public.word.vba.general)
  • Re: send data to excel from c#
    ... ok then I didn't understand VSTO right. ... excel document and lets the user download it. ... Excel.Workbook wb = app.Workbooks.Open(filename, missing, missing, ... Excel file and use the data cache + Server Document functionality. ...
    (microsoft.public.vsnet.vstools.office)
  • Re: How do you skip graphing some data?
    ... and unfilled radar charts) Excel 97-2007. ... If the series has markers only and no points, NAresults in a missing marker corresponding to the missing value. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: How do you skip graphing some data?
    ... and unfilled radar charts) Excel 97-2007. ... If the series has markers only and no points, NAresults in a missing ... Jon Peltier, Microsoft Excel MVP ... How do I make it graph Jan to Apr and Jul but make the May and June ...
    (microsoft.public.excel.misc)
  • Re: Cant find project or library
    ... which calls DLLB which calls DLLC (which is not ... you modules to see what is missing in the hierarchy of calls. ... Excel VBA code. ... hlookups etc. that reference each ...
    (microsoft.public.excel.programming)