Results 1 to 8 of 8

Find missing numbers in unsorted list of numbers

Threaded View

YasserKhalil Find missing numbers in... 05-30-2015, 03:30 PM
mikerickson Re: Find missing numbers in... 05-30-2015, 03:40 PM
YasserKhalil Re: Find missing numbers in... 05-30-2015, 04:14 PM
YasserKhalil Re: Find missing numbers in... 06-01-2015, 03:35 AM
oeldere Re: Find missing numbers in... 06-01-2015, 04:23 AM
YasserKhalil Re: Find missing numbers in... 06-01-2015, 05:15 AM
YasserKhalil Re: Find missing numbers in... 06-01-2015, 05:10 AM
oeldere Re: Find missing numbers in... 06-01-2015, 05:14 AM
  1. 05-30-2015, 03:30 PM #1
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Find missing numbers in unsorted list of numbers

    Hello everyone
    I have in column A >> range("A1:A5") some numbers which are not in a sequence

    I searched and found a formula and I could edit it so as to get the missing numbers according to the min and max numbers
    I need to convert this formula to vba code so as to get the same results as illustrated in Column C
    Thanks advacned for any help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to find missing numbers from a list in excel 2010?
    By prabhakareord in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2013, 03:36 PM
  2. [SOLVED] Find missing entries from a list of sequential numbers and letters in a column?
    By ramim in forum Excel General
    Replies: 4
    Last Post: 07-29-2012, 08:40 AM
  3. I need to find missing invoice numbers from an unorganized list with non-unique entries.
    By ROSH22 in forum Excel General
    Replies: 1
    Last Post: 05-30-2012, 06:29 AM
  4. Find Missing Numbers
    By kapeller in forum Excel General
    Replies: 16
    Last Post: 02-11-2011, 10:09 PM
  5. [SOLVED] to find missing serial numbers in randomly generated numbers
    By B.H. Hadi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2005, 07:00 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1