One play ..
In E1: =IF(ISNUMBER(MATCH(ROWS($1:1),D:D,0)),"",ROWS($1:1 ))
In F1: =IF(ROWS($1:1)COUNT(E:E),"",SMALL(E:E,ROWS($1:1)) )
Copy E1:F1 down to F2000 (the last row). The missing numbers will appear in
col F, neatly bunched at the top. Success? hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"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.