+ Reply to Thread
Results 1 to 2 of 2

Finding duplicates throughout multiple columns

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    North Dakota
    MS-Off Ver
    Excel 2010
    Posts
    10

    Finding duplicates throughout multiple columns

    I need a formula to use in Conditional Formatting to show what rows have matching data in columns E, H, I, J, K, and N, ex: E2=E3, but I only want the criteria highlighted if all columns, E,H,I,J, K, and N all having matching data, E2=E3 and H2=H3 etc.

    See attached WB. Looking at the WB, I would only want row sections 2 and 3, 3 and 4, and 11 and 12 to highlight. I tried to use the formula =AND(E2=E3,H2=H3,I2=I3,J2=J3,K2=K3,N2=N3) but its just not right..
    Attached Files Attached Files
    Last edited by goldstar1; 04-17-2013 at 06:22 PM.

  2. #2
    Registered User
    Join Date
    04-16-2013
    Location
    North Dakota
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Finding duplicates throughout multiple columns

    I found my solution

    =OR(AND($D3=$D2,$G3=$G2,$H3=$H2,$I3=$I2,$J3=$J2,$M3=$M2),AND($D3=$D4,$G3=$G4,$H3=$H2,$I3=$I2,$J3=$J2,$M3=$M2))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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