+ Reply to Thread
Results 1 to 4 of 4

How can I use Remove Duplicate Function to remove all the duplicate numbers and the origin

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    14

    How can I use Remove Duplicate Function to remove all the duplicate numbers and the origin

    I have an advanced question on how I can use the Remove Duplicate Function.
    How can I use the Remove Duplicate Function to remove all the duplicate numbers along with the original numbers that became duplicates too.

    So question is. I'm trying to remove duplicates from a list on my excel 10. I need to not just remove the duplicates but remove both duplicates of the same string of files.

    For example Lets say I have a list like this.

    46
    35
    20
    45
    46
    20
    17
    18

    So If I remove the duplicates Excel would remove the 46 and the 20
    but I want to go much further then that and I want to remove both 46's and both 20's. So I'm left with only 35 45 17 18.
    My real list has over 2000 entries. I'm just made this example up to give you an idea what I'm trying to do.

    Is there a way I can do this?

    thanks zotah

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: How can I use Remove Duplicate Function to remove all the duplicate numbers and the or

    This will do that, but return the numbers in ascending order ... descending if you use LARGE.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    A
    B
    1
    46
    17
    2
    35
    18
    3
    20
    35
    4
    45
    45
    5
    46
    6
    20
    7
    17
    8
    18
    Dave

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How can I use Remove Duplicate Function to remove all the duplicate numbers and the or

    Just a bit shorter
    Enter in B2 and copy down

    **Must be entered with Ctrl+Shift+Enter key combination.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B
    1 Data Results
    2 46 17
    3 35 18
    4 20 35
    5 45 45
    6 46
    7 20
    8 17
    9 18
    10
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: How can I use Remove Duplicate Function to remove all the duplicate numbers and the or

    If you prefer source data order this has to be array entered as AlKey has described above.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    A
    B
    1
    46
    35
    2
    35
    45
    3
    20
    17
    4
    45
    18
    5
    46
    6
    20
    7
    17
    8
    18

+ 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. [SOLVED] remove duplicate digits of numbers doubles list
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2016, 05:33 PM
  2. [SOLVED] How to get reference of duplicate value and set remove duplicate value for future entries
    By bala04msw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2016, 08:13 AM
  3. [SOLVED] How do I remove duplicate numbers from a cell?
    By StreekyD in forum Excel General
    Replies: 7
    Last Post: 11-18-2015, 02:02 PM
  4. Code to remove compare and remove duplicate value between 2 columns
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2015, 02:30 PM
  5. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  6. Remove Duplicate numbers
    By bzenker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2012, 04:55 PM
  7. Replies: 1
    Last Post: 05-25-2006, 03:45 PM

Tags for this Thread

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