Results 1 to 6 of 6

Remove duplicate rows after first occurrence

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2020
    Location
    australia
    MS-Off Ver
    365
    Posts
    112

    Remove duplicate rows after first occurrence

    I have a data set where there are multiple rows with almost duplicate entries.

    I want to remove all the duplicates after the first unique row in the data set.

    I know how to use the unique formula on the employee Id and then track down each one, but its too time consuming.

    Any short way of doing it is greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA To Remove Duplicate Rows
    By tkbuc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2022, 01:38 PM
  2. How to remove duplicate Rows
    By Merrysa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2019, 03:30 AM
  3. [SOLVED] How to sum duplicate values then remove the duplicate rows?
    By terry3218 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2015, 02:38 AM
  4. [SOLVED] Remove Duplicate rows
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-13-2015, 02:34 PM
  5. [SOLVED] Remove duplicate instances of a word from a cell except the last occurrence .
    By rampulaparthi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 04:08 AM
  6. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  7. Excel 2007 : Remove duplicate rows
    By springprogressive in forum Excel General
    Replies: 1
    Last Post: 09-05-2011, 07:32 AM

Tags for this Thread

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