+ Reply to Thread
Results 1 to 3 of 3

Compare columns and remove duplicates

  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    Compare columns and remove duplicates

    Hi,
    I have 6 columns in the sheet1.
    The column A has the address and column E has numbers.
    The first, I have to find the duplicate addressees in column A.
    The second, in the duplicates I have to compare numbers in column E.
    If a row that the number is the biggest will be left and other duplicates will be removed.

    For example,
    A B C D E F
    123 Abc St. 3
    123 Abc St. 45
    123 Abc St. 100
    2244 Qwe Dr. 90

    In the above example, I have to leave the third row '123 Abc St.', because the addresses in three rows are the same,but the number in column E, 100 is the bigger than others.


    So the result will be like below;

    A B C D E F
    123 Abc St. 100
    2244 Qwe Dr. 90

    How can I do this?
    Thanks in advance.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,456

    Re: Compare columns and remove duplicates

    Sort your data first on column E descending
    Then if you use remove dupes first (uppermost) instance is left and other are removed.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Compare columns and remove duplicates

    Thanks, I will try this.

+ 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. Need a macro to Compare multiple sheets and Remove Duplicates
    By ajaypal.sp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2015, 12:18 PM
  2. EDITING compare-two-columns-remove-duplicates FORMULA
    By TheProffesional in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-05-2014, 07:50 AM
  3. Compare 2 columns and remove duplicates in both columns when found
    By 1dtms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2013, 02:19 AM
  4. [SOLVED] Compare two rows of numbers. Remove the duplicates
    By nicdyb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-20-2012, 06:08 AM
  5. How to compare two columns and remove duplicates?
    By username123 in forum Excel General
    Replies: 15
    Last Post: 07-05-2006, 11:06 AM
  6. [SOLVED] how do i compare two columns and remove duplicates?
    By aljernon805 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2005, 12:10 PM
  7. compare two columns and remove duplicates
    By Moni39 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2005, 02:06 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