Results 1 to 3 of 3

Thread: Excel Function Removing Even Duplicates

  1. #1

    Excel Function Removing Even Duplicates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I want to pull the very last odd duplicate. Example below, I want to pull out A3, and C5 and delete the rest. Is there a function that will allow me to do this? Thank you so much in advance!

    For example,

    Column 1 Column 2
    A 1
    A 2
    A 3
    B 1
    B 2
    C 1
    C 2
    C 3
    C 4
    C 5
    D 1
    D 2
    D 3
    D 4

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Assuming data starts in Row2, in C2 enter helper formula:

    =AND(A3<>A2,MOD(B2,2)=1)

    copied down

    Then apply AutoFilter (Data|Filter) to the 3 columns.

    Filter column 3 for FALSE and delete those rows.

    Remove Autofilter and delete column 3 for final list.


  3. #3
    Thank you for your help! it works!

    The data is actually lil bit trickier! Apply the same concept, Example below, I want to pull out A4, and C9 and delete the rest. Is it possible?

    What if the data is


    Column 1 Column 2
    A 1
    A 2
    A 4
    B 1
    B 2
    C 1
    C 2
    C 5
    C 7
    C 9
    D 1
    D 2
    D 4
    D 6

Tags for this Thread

Posting Permissions

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