Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate Rows (2002)

    I have a sheet with 3000 rows of numbers and I want to get rid of duplicates. A number could be on the sheet twice, and I want BOTH gone from the worksheet. Thanks,

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Duplicate Rows (2002)

    I will assume your numbers are from A2:A3001 (A1 has a header) and B is blank [Adapt as neccessary)

    In B2 enter:
    <pre>=COUNTIF(A:A,A2)=1</pre>

    Autofill this down the column [move the mouse over the bottom right corner and when the cursor changes to small "+", dbl-click]

    The select column B and data -filter - autofilter
    Select the dropdown arrow in B1 and choose "False"
    Go to the last row of data and select the row
    Then, holding the shift key, go to the the first row past the header and select that [All the rows in between will be selected]
    Press edit - delete - entire row.
    Select column B and delete it

    You will be left with only the rows which had 1 and only 1 value
    Steve

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Rows (2002)

    That worked. THANKS!

Posting Permissions

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