Please Help!!!!

[rosariocristina]

i KNOW NOTHING ABOUT EXCEL, AND I AVE BEEN TRYING TO FIGURE IT OUT FOR
TO LONG HOW IT WORKS, I JUST WANNA DO A SIMPLE TASK, I WANNA KNOW IF
ITS POSSIBLE: I HAVE A BUNCH OF NUMBER FROM 0000 TO 9999 AND I WANT TO
KNOW WHICH NUMBERS ARE NOT IN MY LIST.

 

[Bernard Liengme]

In A1 enter 0, in A2 enter 1
Use the mouse to select A1:A2 and drag the fill handle (little square in
lower right of A2) down to row 9999.
Now you have 0 to 9999 in column A
Type your numbers in column D (in D1, D2, D3...). Let's say the last one is
in D500
In B1 enter =VLOOKUP(A1,$D$1:$D$500,1,FALSE) {change the 500 to the correct
number}
Double click the fill handle of B1 so as to copy the formula down the column
If, for example, the D column contains 8, then B8 will read 8
But if there is no 8 in the D column, B8 will read #N/A
best wishes
Please turn off caps - that is considered shouting in newsgroups!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rosariocristina"

 

[Don Guillett]

1. Please help is not a subject line where you will get much help. Clearly
state your question with a short meaningful subject line.
2. Do NOT type in all upper case. It is considered very bad netiquette.
3. If your numbers are in col a, try this array formula in the next column.
Array formulas must be entered using ctrl+shift+enter instead of just enter.
=INDEX(ROW($1:$115),SMALL(IF(COUNTIF(A$1:A$15,ROW($1:$115))=0,ROW($1:$115)),ROWS($1:1))

Or you can use a macro
Or search the archives

 

[Don Guillett]

A macro to do it properly.
right click sheet tab>view code>copy/paste the macro below>alt f8 to goto
macros to run

Sub findmissingnumbers()'list missing from col a in col b
counter = 0
For i = 1 To Cells(Rows.Count, "a").End(xlUp).Row - 1
If Cells(i + 1, 1) <> Cells(i, 1) + 1 Then
Cells(counter + 1, 2) = Cells(i, 1) + 1
counter = counter + 1
End If
Next i
End Sub

 

[Don Guillett]

Doesn't work for all. Use the array formula instead