+ Reply to Thread
Results 1 to 2 of 2

How to remove all except one based on the duplicate info on the other column

Hybrid View

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    CA, US
    MS-Off Ver
    Excel 2007
    Posts
    21

    How to remove all except one based on the duplicate info on the other column

    Hello friends,
    How are you?

    I am in great need of help.
    I have to organize the order sheet and it has about 10,000 rows.

    What needs to be done is to remove all the values except one based on the duplicated values on the other column.
    Let me show an example.

    Column A  Column B
    12345678  $10.00
    12345678  $10.00
    44448888  $15.00
    44448888  $15.00
    44448888  $15.00
    00033344  $10.00
    00033344  $10.00

    This should organized into like the one below

    Column A  Column B
    12345678  $10.00
    12345678
    44448888  $15.00
    44448888
    44448888
    00033344  $10.00
    00033344

    all the values for the duplicated values on the column A were removed except for the first one.
    (it can be last one or the first one, as long as one remains)

    I was doing it manually for the past one hour but I have barely dont couple hundred and I have more than 10,000 left.
    And this needs to be done by no later than 1am. Please help.

    (I am not really familiar with the formula and the function so I would be really appreciated if you can also explain how the formula should be applied)

    Thank you!
    Sample.xlsx

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: How to remove all except one based on the duplicate info on the other column

    In c2, paste this formula and drag down

    =IF(A2<>A3,B2,"")
    Last edited by elayaz; 07-24-2013 at 03:14 AM.

+ 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. How to remove all except one based on the duplicate info on the other column
    By nutstae in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-24-2013, 04:18 AM
  2. Replies: 3
    Last Post: 07-24-2013, 04:09 AM
  3. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  4. Find duplicate info in two columns and copy info from duplicate rows
    By USGS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-12-2011, 07:31 PM
  5. edit macro that is pasting info to check column for duplicate info
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2009, 05:55 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