• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find Duplicate Rows only

K

KAS

New Member
Hello.... I'm certain Excel can do this BUT I have not been able to figure it out :(.....so.... I'm hoping someone here can help!

Here's the situation:
  1. Excel Workbook with 3-6 tabs, 1 being an index of sorts. The 3-5 tabs are separate tests.
  2. Using a formula I put the data from the various tests on Sheet 1, i.e. the Index Sheet, easy enough!
  3. Now, I will have 3-5 columns with 55 to 103 rows of data .... here's where I need help......
  4. I want to compare each row individually, not column but row, and bold (or color) the duplicate values in that row only. It's time consuming and hard on the eyes :confused: to do it manually.
I've attached a sample file so you can see what I mean. In my file I've already bolded the duplicates down to row 12 so you can see what I mean.

I know it doesn't seem like a big deal to just look them over but when you do several of these a day it sure does get challenging! :DD

Thanks!
 

Attachments

  • Copy of Practice.xlsm
    70.4 KB · Views: 7
Well yes and no.... sorry .... I uploaded the file before I saved the bold! This one should look bolded.
 

Attachments

  • Copy of Practice.xlsm
    70.4 KB · Views: 3
Hi ,

Looking at your manually bolded results , what I can conclude is that the duplicate should exist in the same row ; this is slightly different from finding duplicate rows.

If my assumption is correct , what we need to do is for each cell in column B , see if the corresponding cell in column C or column D is the same. Similarly for the other two columns.

See this file.

Narayan
 

Attachments

  • Copy of Practice (1).xlsm
    65.4 KB · Views: 14
Yes, you are correct, I misspoke -- I do not need to find duplicate rows but duplicate values in the same row.

I looked at the file and it certainly looks good; how did you accomplish that? Can I simply bold the duplicates or do I have to use a color?

Thanks!
 
Hi ,

What has been used is Conditional Formatting ; click on this , and see the 3 additional rules there ; instead of colouring the cells , you can make the font BOLD ; just change the formats.

Narayan
 
Thank you Narayan, I was playing with Conditional Formatting but I could not figure it out for the life of me! So simple :).... I really appreciate your help!
 
Shoot..... I just realized that there's a problem with this .... I can compare columns B & C and C & D but when I try to compare B & D it includes column C and highlights everything.

I need to look at row 1 (in this case 3 values) and bold any of the values that duplicates whether they are in column B, C, or D.

Can I do this with conditional formatting? Obviously I'm not very good at it! :oops:
 
You must log in or register to reply here.
Back
Top