# Thread: Missing number from list (Excel 2003)

1. ## Missing number from list (Excel 2003)

I have a long list of numbers. They are in groups of 24. I need to find the 2 or 3 sequential numbers that are missing from the list. For instance, 2531is missing. Is there a function or easy way to do this?

2. ## Re: Missing number from list (Excel 2003)

In C1 you could enter:
<pre>=Min(A:A)</pre>

Then in C2 enter:
<pre>=IF(MAX(A:A)>C1,1+C1,"No More")</pre>

copy C2 as far as needed (if it says "No More" you are too far...)

In D1 enter:
<pre>=IF(COUNTIF(A:A,C1)=0,"Missing","")</pre>

Copy D1 down the column as far as column C goes. it will display "Missing" for each one that is missing.

Steve

3. ## Re: Missing number from list (Excel 2003)

Very elegant, well done, Steve.

4. ## Re: Missing number from list (Excel 2003)

=IF(OR(A2=A1, A2=A1+1), "", "missing")

5. ## Re: Missing number from list (Excel 2003)

Caveat, it doesn't take into account the grouping of 24 as I came up with 2531 and 2535

In B1, enter =MIN(A1:A360)
In B2, enter =MAX(A1:A360)

In C1 array enter,

=SUBSTITUTE(MCONCAT(IF(ISNA(MATCH(SETV(ROW(INDIREC T(B1&":"&B2))),A1:A360,0)),","&GETV(),"")),",","", 1)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•