Results 1 to 2 of 2

Using filter to highlight/filter duplicates in multiple columns but within 1 day

Threaded View

DaveBre Using filter to... 09-24-2014, 10:35 PM
morevijay1982 Re: Using filter to... 09-25-2014, 04:07 AM
  1. #1
    Forum Contributor
    Join Date
    05-04-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    125

    Using filter to highlight/filter duplicates in multiple columns but within 1 day

    Hi all,

    I've searched through the forums but can find an example of my problem.

    I have a large dataset of credit card transactions (>10,000) and I'm reviewing and I'm trying to highlight duplicates in multiple columns. Essentially I'm trying to locate transactions which have been processed with 1 day of each other at the same store, same business area and that are over a certain value ($100 in the example).

    I've attached an example of my data along with expected results, any help would be much appreciated.

    Thanks

    David
    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. [SOLVED] Highlight Duplicates Between Multiple Columns
    By WorkwearExp in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-10-2014, 08:12 AM
  2. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  3. Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables
    By tash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 05:32 PM
  4. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  5. Replies: 5
    Last Post: 07-05-2011, 06:25 PM

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