please help with excell formula

[capitano10]

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

Thanks

[TABLE="width: 210"]
<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 70"]ID[/TD]
[TD="class: xl65, width: 70"]Name[/TD]
[TD="class: xl65, width: 70"]Match[/TD]
[/TR]
[TR]
[TD="class: xl65"]88100[/TD]
[TD="class: xl65"]james[/TD]
[TD="class: xl65"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl65"]88100[/TD]
[TD="class: xl65"]james[/TD]
[TD="class: xl65"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl65"]88100[/TD]
[TD="class: xl65"]Mick[/TD]
[TD="class: xl65"]FALSE[/TD]
[/TR]
[TR]
[TD="class: xl65"]89100[/TD]
[TD="class: xl65"]John[/TD]
[TD="class: xl65"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl65"]89100[/TD]
[TD="class: xl65"]John[/TD]
[TD="class: xl65"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl65"]89100[/TD]
[TD="class: xl65"]Ken[/TD]
[TD="class: xl65"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

 

[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

[TABLE="width: 210"]
<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 70"]ID[/TD]
[TD="class: xl64, width: 70"]Name[/TD]
[TD="class: xl64, width: 70"]Match[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]88100[/TD]
[TD="class: xl64, width: 70"]james[/TD]
[TD="class: xl63"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]88100[/TD]
[TD="class: xl64, width: 70"]james[/TD]
[TD="class: xl63"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]88100[/TD]
[TD="class: xl64, width: 70"]Mick[/TD]
[TD="class: xl63"]FALSE[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]89100[/TD]
[TD="class: xl64, width: 70"]John[/TD]
[TD="class: xl63"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]89100[/TD]
[TD="class: xl64, width: 70"]John[/TD]
[TD="class: xl63"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 70, align: right"]89100[/TD]
[TD="class: xl64, width: 70"]Ken[/TD]
[TD="class: xl63"]FALSE[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 70, align: right"]89102[/TD]
[TD="class: xl65, width: 70"]Erick[/TD]
[TD="class: xl63"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

 

[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[TABLE="width: 602"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]Debtor Name[/TD]
[TD]Match[/TD]
[/TR]
[TR]
[TD]RF02903778000000090220759[/TD]
[TD]jack[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF02903778000000090220759[/TD]
[TD]erick[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF03903778000000090223069[/TD]
[TD]John[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF03903778000000090223069[/TD]
[TD]Mark[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF03903778000000090223069[/TD]
[TD]john[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF03903778000000090223069[/TD]
[TD]MArk[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]