+ Reply to Thread
Results 1 to 6 of 6

Duplicate Values looking at 2 columns

  1. #1
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Duplicate Values looking at 2 columns

    Hi All,

    I have a column of names in column A

    in column B I have dates

    I want to do a conditional format where if the name and date in row 1 happens again, it will be highlighted

    Example,

    A B
    John Doe 31/05/2015

    if this happens twice, i want to highlight it

    Thanks in advance

  2. #2
    Registered User
    Join Date
    06-16-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Duplicate Values looking at 2 columns

    =COUNTIFS($A:$A,$A1,$B:$B,$B1)>1

    This will highlight only duplicated value not the Original One.
    Last edited by dan4ish; 06-01-2015 at 07:05 AM.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Duplicate Values looking at 2 columns

    The response at Post 2 seems to highlight them all. ThCF used in the attached file will highlight only the duplicates...
    Attached Files Attached Files
    Glenn



  4. #4
    Registered User
    Join Date
    04-05-2015
    Location
    Saihat, Saudi Arabia
    MS-Off Ver
    2013
    Posts
    46

    Re: Duplicate Values looking at 2 columns

    Hi,
    In the conditional format select Duplicate values and apply to the range in column A.Please see the attached file.
    Thanks.
    Book1.xlsx

  5. #5
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Duplicate Values looking at 2 columns

    Thanks all for the replies,

    I went with Glenns formula

    Rep added to all

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Duplicate Values looking at 2 columns

    Thanks for the Reputation that you have added. It's much appreciated.

+ 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. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. [SOLVED] Find duplicate values in within 2 columns
    By bigroo1958 in forum Excel General
    Replies: 2
    Last Post: 01-13-2014, 10:42 AM
  3. [SOLVED] Merge duplicate values with other columns of different values
    By lesday in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 04:18 PM
  4. Duplicate values in two columns
    By Karen123 in forum Excel General
    Replies: 1
    Last Post: 03-21-2011, 05:27 AM
  5. Getting Duplicate Row values into Columns
    By dirtmcgirt in forum Excel General
    Replies: 2
    Last Post: 12-06-2007, 11:50 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