+ Reply to Thread
Results 1 to 4 of 4

Find Duplicates After Filtering

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    houston
    MS-Off Ver
    Excel 2013
    Posts
    4

    Find Duplicates After Filtering

    I have a list of first column is Employee Id Numbers, Second column is Dates of checks issued. I want to find if there are any duplicate dates for a single employee ID number. I thought if I filtered the ID number and put a conditional value for Duplicates on dates I would be able to quickly see if any of the dates were the same. However since the conditional value is reading all the dates outside the filter everything is Highlighted. Is there anyway to get the conditional value to apply only to dates shown?

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Find Duplicates After Filtering

    Excel has a remove duplicates function. Have you taken a look at that?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    houston
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Find Duplicates After Filtering

    Thanks but I have no interest in removing duplicates. I just need to see if any employee was paid twice on the same day. There are about 60 employees with 24-26 checks each so it would be much easier to just find the duplicates (if there are any)in each Employee Number.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Find Duplicates After Filtering

    You could use INDEX/MATCH to identify duplicates, but without a sample workbook that's about as detailed as I can get.

+ 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. Macro to find duplicates, concatenate cells, then delete old duplicates
    By givemepuppies in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-04-2016, 02:43 AM
  2. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  3. find duplicates for visible cells after filtering for a column
    By sravan.rathnam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 06:41 AM
  4. Filtering Duplicates
    By djscissorhands in forum Excel General
    Replies: 8
    Last Post: 11-06-2010, 08:33 AM
  5. Filtering Duplicates
    By attory in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2010, 11:44 AM

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