+ Reply to Thread
Results 1 to 4 of 4

Remove row if duplicate ID# in column

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    WA, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Remove row if duplicate ID# in column

    I found the following elsewhere which works almost flawlessly, 'cept it removes the rows that I have already modified. How do I modify this so it removes the second row instead of the first?
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Remove row if duplicate ID# in column

    Usta,

    Welcome to the Excel Forum.


    Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


    Please Login or Register  to view this content.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    WA, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Remove row if duplicate ID# in column

    Thanks! That worked perfectly!

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Remove row if duplicate ID# in column

    Usta,

    You are very welcome. Glad I could help.

    Thanks for the feedback.

    Come back anytime.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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