+ Reply to Thread
Results 1 to 3 of 3

VBA to highlight duplicates in combinations of 2 ranges

  1. #1
    Registered User
    Join Date
    01-19-2023
    Location
    Bucharest, Romania
    MS-Off Ver
    2016
    Posts
    2

    VBA to highlight duplicates in combinations of 2 ranges

    I would appreciate your help in the following issue: 3 columns with dates, 6 columns with names. Any name can be in any column J-O, any date can be in any column G-i. Even on different rows.

    One name cannot be assigned a date >= 2 times (the guy can't be auditing in 2 places at the same time).
    When this happens, I need highlighted the duplicate date and name.

    I have included 2 images ("Registru", where I need to input the VBA code and "Registru2", where I exemplified finding the duplicates using 18 additional columns concatenating date + name).

    Thank you very much,

    Img2.jpg
    Img3.jpg
    Attached Files Attached Files
    Last edited by Netvice; 01-19-2023 at 03:18 PM. Reason: Attach excel file

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: VBA to highlight duplicates in combinations of 2 ranges

    You need to upload an actual workbook otherwise you cause someone to have to recreate your sheets and no one wants to do that.
    See the yellow area near the top of the page for instructions.

  3. #3
    Registered User
    Join Date
    01-19-2023
    Location
    Bucharest, Romania
    MS-Off Ver
    2016
    Posts
    2

    Re: VBA to highlight duplicates in combinations of 2 ranges

    Done, thank you.

+ 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. Highlight duplicates in 2 columns: Keep duplicates, delete rest
    By tobyvb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2021, 06:27 AM
  2. MACRO for all possible combinations including duplicates.
    By danilhigg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2020, 01:37 PM
  3. Replies: 14
    Last Post: 04-20-2016, 03:31 PM
  4. Ranges - list of all possible combinations
    By stacylynn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2015, 05:15 PM
  5. Delete duplicates value combinations from two columns
    By Julia2937 in forum Excel General
    Replies: 2
    Last Post: 03-29-2013, 07:03 PM
  6. Macro to match combinations with 4 or more similar numbers and highlight them
    By flexalong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2009, 06:21 AM
  7. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 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