Help with a macro that flags duplicates with different values

[armando12345]

Hi All,

I've been racking my brain on how I can do this but I just can't seem to figure it out. I've attached an excel spreadsheet for you all to look at.

Basically, I have a list of names/primary keys and they have 4 values associated with them on each line: Day 1,2,3 and 4.

What I need is to be able to flag duplicates in the Name column but whose values don't match across each day. So if day 1 on John's first line = day 1 on John's second and third and fourth line etc. then we are good. I would also want to do the same for day 2, 3 and 4. So, if John's Day 1= Day 1, Day 2=Day2, and so on, across all of his rows, then I DON'T want to flag John.

What I DO want to flag is when the person's days don't match across all rows. So, for example, Jesse would be flagged because their day 1 doesn't = day 1 across all lines. I want to flag if ANY of the days don't match across all rows. so if day 1,2,3 all matched but day 4 didn't I'd want to flag that.

I've racked my brain on how to do this with a formula but I can't figure it out. I don't care if it's done with a formula or a macro but I just need help!

PLEASE SOMEONE

[oeldere]

G2 =B3&C3&D3&E3&F3 and drag down

H2 =Countif($G$3:$G$17,G3) and drag down

Then filter on column H and select 2 and 3 (the values who are duplicated).

See the attached file.

[nankw83]

Hi armando,

Try the below code based on your sample file

Please Login or Register  to view this content.