+ Reply to Thread
Results 1 to 5 of 5

Extract unique numbers

  1. #1
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Extract unique numbers

    hi guys, i have a table with forty five numbers, what i want is to extract in a column the numbers they did not appeared at all.thank you!

  2. #2
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: Extract unique numbers

    just the values the did not pull out from the box! please see example at the workbook i attached.

    thanks again from my heart

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Extract unique numbers

    Please try M2 copy down

    =IFERROR(AGGREGATE(15,6,$A$1:$J$5/NOT(COUNTIF($E$10:$E$32,$A$1:$J$5)+($A$1:$J$5="")),ROWS(M$2:M2)),"")
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,953

    Re: Extract unique numbers

    Using helper columns.
    2d matrix to column 'M':
    Please Login or Register  to view this content.
    Test if missing from random list:
    Please Login or Register  to view this content.
    List of missing numbers (array entered** in column O):
    Please Login or Register  to view this content.
    **...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Attached Files Attached Files
    Ben Van Johnson

  5. #5
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: Extract unique numbers

    thanks proton!is working!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 07-04-2016, 04:52 PM
  2. Extract unique numbers from Word and search for them in Excel
    By Reen in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 07-08-2014, 04:28 AM
  3. Replies: 8
    Last Post: 01-10-2014, 10:55 AM
  4. Extract unique numbers from a list
    By excelbee in forum Excel General
    Replies: 7
    Last Post: 08-11-2012, 09:00 AM
  5. Replies: 2
    Last Post: 05-24-2012, 05:05 PM
  6. how to extract unique numbers once from a list of repeated numbers?
    By stuart.kwok@gmail.com in forum Excel General
    Replies: 2
    Last Post: 05-02-2006, 11:20 AM
  7. [SOLVED] Extract Unique Values, Then Extract Again to Remove Suffixes
    By Karl Burrows in forum Excel General
    Replies: 23
    Last Post: 06-25-2005, 08:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1