LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 41
Default How can I extract a list of numbers missing in a list?

I have items that have been assigned an ID number. How can I extract a list
of unassigned numbers? I.E. I have number range starting with
7200000-7232000. How can I extract a list of unassigned numbers from this
list of numbers? I know some of the Excel functions but I could not figure
this out.
--
nfw
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify missing numbers in list Lj Excel Worksheet Functions 5 July 31st 08 03:09 AM
Find missing numbers in a list contar Excel Discussion (Misc queries) 9 July 5th 07 06:39 AM
Find Missing Numbers in a List millie6169 Excel Discussion (Misc queries) 6 November 12th 06 02:59 AM
MISSING NUMBERS IN LIST jpfrmnm Excel Discussion (Misc queries) 2 November 10th 06 09:30 PM
how to extract unique numbers once from a list of repeated numbers? [email protected] Excel Discussion (Misc queries) 2 May 2nd 06 04:17 PM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"