Re: Please Help!!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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"
<rosariocristina.274len_1146481801.3897@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:rosariocristina.274len_1146481801.3897@xxxxxxxxxxxxxxxxxxxxxxxx

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.


--
rosariocristina
------------------------------------------------------------------------
rosariocristina's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=34004
View this thread: http://www.excelforum.com/showthread.php?threadid=537689



.

Relevant Pages