please help with excell formula

[capitano10]

I would need to have the formula to reflect the below match in colums C

Thanks

ID	Name	Match
88100	james	TRUE
88100	james	TRUE
88100	Mick	FALSE
89100	John	TRUE
89100	John	TRUE
89100	Ken	FALSE

<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

Place this formula in C2 and copy down for all rows:

=COUNTIFS(A:A,A2,B:B,B2)>1

 

[capitano10]

many thanks for the reply. however it seems to give me false instead of true e viceversa

 

[LMacD]

I tried Joe's formula it work for me.

Did you copy and paste the formula?

Is
ID colA
Name column B
Match column C

 

[Joe4]

many thanks for the reply. however it seems to give me false instead of true e viceversa

That usually means that your formula does not align with your ranges.
Note that my formula, as written, only works if the two columns are A and B, and you are placing the formula in row 2.
If any of these conditions are different, the initial formula will need to be altered.
If you are not sure how to do that, please let us know the conditions.

 

[capitano10]

Thanks. i copied and paste in a new sheet and it worked. Howere when i have a single entry like the below for erick i receive a false but it should be true in this case

ID	Name	Match
88100	james	TRUE
88100	james	TRUE
88100	Mick	FALSE
89100	John	TRUE
89100	John	TRUE
89100	Ken	FALSE
89102	Erick	FALSE

<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>
</tbody>

 

[Joe4]

Howere when i have a single entry like the below for erick i receive a false but it should be true in this case

I think you need to clarify your desired logic.
Based on your original example, it looked like you wanted to return TRUE when the ID/Name combination appeared more than one time.
If that is not what you are after, you will need to explain exactly what qualifies a "match" and what doesn't.

 

[capitano10]

sorry yes let me explain further

In the column A i have the ids and in the colums B the names. The ids remain the same for the same name and change if the name is different. it may happen that one id has a name and in that case i would have to receive a true answer

Thanks again guys

 

[Joe4]

OK, that is very different than what I thought you were trying to do.
Enter this in C2 and copy down for all rows.

=OR(A2<>A1,AND(A2=A1,B2=B1))

Assuming that your data is sorted by columns A and B, it should work.

 

[capitano10]

thank you very much joe4

I still have an issue as i now receive 2 values as false with the same id



ID

	Debtor Name	Match
RF02903778000000090220759	jack	FALSE
RF02903778000000090220759	erick	FALSE
RF03903778000000090223069	John	FALSE
RF03903778000000090223069	Mark	FALSE
RF03903778000000090223069	john	FALSE
RF03903778000000090223069	MArk	FALSE

<colgroup><col><col><col></colgroup><tbody>
</tbody>