Boy I know this is dumb, but this is the first time I've had to ask a
question. Back on 2/4 ( I think) I asked a question in this forum, it said
it was posted, but I cannot find it..I figured when I signed back in with my
name, it would be a way to find it. I also clicked " notify me"...the
question was...I have a list of numbers that are supposed to inlclude all
the numbers from, say, 1 to 100. That list may be 67 numbers long or 122,
or whatever. I am new to this Excel. I need to find a way fo get a list
( or soemthing) of the numbers that are NOT in the list which should be.
For example if 76 and 3 are missing, I need these two. thanks so much.

Bill Nock .

Try he

http://groups.google.com/group/micro...billnock+excel

for this reply:

One play ..
Assume your source data runs in A2 down
In B2:
=IF(ROWS($1:1)+700-1799,"",IF(ISNUMBER(MATCH(ROWS($1:1)+700-1,A:A,0)),"",ROWS($1:1)+700-1))
Copy B2 down by 100 rows to cover the full spread of numbers to be checked,
ie # of nums from start num to end num (700 to 799). Note that the extent of
source data in col A does not matter in the copy -down.

Then place in C2:
=IF(ROWS($1:1)COUNT(B:B),"",SMALL(B:B,ROWS($1:1)) )
Copy C2 down just enough ie until blanks are returned. All the missing nums
in between the start to end nums will appear neatly packed at the top. Wave
your success, hit YES below ..
--
Max
Singapore

"billnock" wrote in message
...
Boy I know this is dumb, but this is the first time I've had to ask a
question. Back on 2/4 ( I think) I asked a question in this forum, it
said
it was posted, but I cannot find it..I figured when I signed back in with
my
name, it would be a way to find it. I also clicked " notify me"...the
question was...I have a list of numbers that are supposed to inlclude all
the numbers from, say, 1 to 100. That list may be 67 numbers long or
122,
or whatever. I am new to this Excel. I need to find a way fo get a list
( or soemthing) of the numbers that are NOT in the list which should be.
For example if 76 and 3 are missing, I need these two. thanks so much.

Bill Nock .

"billnock" wrote:
Subject: How do I find my question?

You are using the MSDG web interface. So click on Help in near the
upper-right corner, and click on "Search for discussions".

But be forewarned: there is no guarantee you will be able to find your
postings.
First, every newsgroup (aka discussion group) has its share of defects. The
MSDG web interface seems to be the worst. But I often cannot find my
postings using Google Groups "advanced search", which some people tout as
"the" solution. (Not!)


I so clicked " notify me"

I don't use the MSDG web interface much, and I never use that feature. But
based on frequent complaints, I believe I can say that feature is infamous
for its failing.


----- original message -----

"billnock" wrote:

Boy I know this is dumb, but this is the first time I've had to ask a
question. Back on 2/4 ( I think) I asked a question in this forum, it said
it was posted, but I cannot find it..alI figured when I signed back in with my
name, it would be a way to find it. I so clicked " notify me"...the
question was...I have a list of numbers that are supposed to inlclude all
the numbers from, say, 1 to 100. That list may be 67 numbers long or 122,
or whatever. I am new to this Excel. I need to find a way fo get a list
( or soemthing) of the numbers that are NOT in the list which should be.
For example if 76 and 3 are missing, I need these two. thanks so much.

Bill Nock .

Click on your name "billnock" in your post. In the resulting user profile
pop-up, click on "Recent posts by this user" in the top right corner. And
that would surface all of your recent threads. Plunge into your threads,
engage those responders ...
--
Max
Singapore
---
"billnock" wrote:
Boy I know this is dumb, but this is the first time I've had to ask a
question. Back on 2/4 ( I think) I asked a question in this forum, it said
it was posted, but I cannot find it..I figured when I signed back in with my
name, it would be a way to find it. I also clicked " notify me"...the
question was...I have a list of numbers that are supposed to inlclude all
the numbers from, say, 1 to 100. That list may be 67 numbers long or 122,
or whatever. I am new to this Excel. I need to find a way fo get a list
( or soemthing) of the numbers that are NOT in the list which should be.
For example if 76 and 3 are missing, I need these two. thanks so much.

Bill Nock .

After signing in, click on Edit My Profile icon (Just to left of Sign Out and
Help at top right of main part of screen).

Scroll down the screen and up to 4 of your posts will be shown. If you have
more than 4 then click on Show all my notifications. The bottom ones are the
most recent. Just click on the link and it takes you to the post.

Note that the list in your profile is only for the ones you for which
requested notifications.



--
Regards,

OssieMac


"billnock" wrote:

Boy I know this is dumb, but this is the first time I've had to ask a
question. Back on 2/4 ( I think) I asked a question in this forum, it said
it was posted, but I cannot find it..I figured when I signed back in with my
name, it would be a way to find it. I also clicked " notify me"...the
question was...I have a list of numbers that are supposed to inlclude all
the numbers from, say, 1 to 100. That list may be 67 numbers long or 122,
or whatever. I am new to this Excel. I need to find a way fo get a list
( or soemthing) of the numbers that are NOT in the list which should be.
For example if 76 and 3 are missing, I need these two. thanks so much.

Bill Nock .