In E1 paste this formula

=IF(ROW(D1)(MAX(D:D)-MIN(D:D)),"Enough",IF(ISERROR(MATCH(MIN(D:D)+ROW(D 1),D:D,FALSE)),MIN(D:D)+ROW(D1),""))

This is an array formula.

Enter with CTRL + SHIFT + Enter.

Double-click to copy down as far as you have data in column D

Or drag/copy down until "Enough" shows up.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 13:35:01 -0800, Vic
wrote:

How do I find missing numbers?
I have numbers from 1 to 500 in columns D1 to D2000 (some numbers may appear
in several cells). However, some numbers don't appear at all. How do I find
missing numbers?
Thnak you.