Results 1 to 8 of 8

Formula for highlighting duplicates with value in different column

Threaded View

  1. 08-30-2020, 08:16 AM #1
    antoinb
    antoinb is offline
    Registered User
    Join Date
    10-10-2014
    Location
    Dublin Ireland
    MS-Off Ver
    Microsoft 365 MSO (Version 2309 Build 16.0.16827.20130)
    Posts
    36

    Formula for highlighting duplicates with value in different column

    Im looking for all the instances where there is a 2 in column i (MPN) and the matching value in column e (code) has a duplicate.
    I would then like to highlight the duplicates in column e.

    Im using Excel 2010

    Any help appreciated
    Attached Files Attached Files
    Last edited by antoinb; 08-30-2020 at 09:05 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to remove duplicates and return a certain cell's text if duplicates found
    By O.Anderson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-27-2018, 07:17 AM
  2. [SOLVED] Identification of duplicates numbers in a column and print as duplicates with that number
    By kswapnadevi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2017, 05:25 AM
  3. [SOLVED] Macro to find duplicates, concatenate cells, then delete old duplicates (2)
    By cny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 06:05 AM
  4. need a single formula to detect duplicates and return same value in case of duplicates
    By amu in forum Excel General
    Replies: 1
    Last Post: 07-30-2014, 02:37 PM
  5. Finding duplicates and approximate duplicates on two separate lists of accounts
    By kmurphy372 in forum Excel General
    Replies: 2
    Last Post: 12-27-2013, 09:24 AM
  6. [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
  7. Duplicates with spelling errors, not exact duplicates and partial duplicates
    By ViaPointe in forum Excel General
    Replies: 3
    Last Post: 03-09-2011, 07:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1