If data matches in one column, check 2nd column matches [Solved/Closed]

Report
Posts
2
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013
-
Posts
2
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013
-
I've been trying to figure this out for days, I'm sure it's possible but can't get it to work.

I have a set of data - in one column there are reference numbers. Sometimes the reference will only appear once, other times it will be duplicated.
Where a reference is duplicated, I want to check in the next column if the Name matches - I need to be able to identify the ones where the reference matches and the name doesn't, don't mind how it does it

In the example below, there are 3 columns of data and 5 rows...
The first row appears only once, so there is nothing to match - would prefer this to default to a Match.
The 2nd reference is duplicated, in row 2 & 3 and has matching names in column B so both of those should Match
In row 4, the reference is duplicated in row 5 however the names in 4 & 5 don't match.

12345 John
12346 John Match
12346 John Match
12347 John Doesn't match
12347 Jack Doesn't match

Hoping someone can help me with this!
Thanks in advance

2 replies

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
Vickylouise, Good morning.

I did an example for you.
https://www.cjoint.com/?CJhp3GgGAS0

I used only simple functions.
IF , COUNTIF , SUMPRODUCT

Please, take a look at it and tell us if it is what you desire.
I hope it helps.

Greetings from Brazil.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013

Hi Mazzaropi

It worked!
Thank you very much, really appreciate your help :)