Results 1 to 15 of 15

Identify duplicates of two columns combined

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2024
    Location
    Mason, Ohio
    MS-Off Ver
    2021
    Posts
    7

    Identify duplicates of two columns combined

    Problem statement - There are multiple departments and a particular software can be used in more than one department. In this case S1 is being used by Dept A and Dept B. I need to identify such softwares. I can't use the inbuilt duplicate function because that will also highlight S1 version B also being used. Also it will highlight S3 as it's different versions are being used by the same department Dept B. So in this case it should just highlight S1 as it is being used by 2 different departments. The requirement is to find the same software being used by more than 1 department. Have tried Vlookup but no luck.[ATTACH]855598[/ATTACH
    Attached Files Attached Files
    Last edited by pratikkhanna; 01-13-2024 at 09:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Best Formula Advice
    By CarlW1179 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2024, 06:35 AM
  2. Need formula advice
    By kikis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2015, 06:14 AM
  3. VBA code advice/Excel advice for summing groups of numbers
    By paulblower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2014, 05:47 AM
  4. IF Formula advice
    By jkility in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-12-2014, 11:23 AM
  5. Formula Advice
    By max308 in forum Excel General
    Replies: 7
    Last Post: 09-07-2011, 01:53 PM
  6. [SOLVED] need formula advice
    By CdnMichael in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2006, 07:20 PM
  7. [SOLVED] Advice on formula Please
    By Tempy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2005, 02:06 PM

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