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]

As I mentioned, in order for this formula to work, you wlll need to have your two columns sorted, so all the "like" records for a person are in a row.
So first sort your data, with ID as your primary sort and Debtor Name as your secondary sort.

 

[capitano10]

it seems to work

thank you very much joe4 and apologies for the confusion

 

[Joe4]

You are welcome.

 

[capitano10]

i have just noticed that if the spell of the name is incorrect i would have duplicate ids. Would it be possible to have only on id ?

Thanks

[TABLE="width: 746"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]RF46903778000000090128884 MArk[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF47903778000000090220046 Roby[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF47903778000000090220046[/TD]
[TD]Rober[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]RF47903778000000090220046[/TD]
[TD]rob[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

i have just noticed that if the spell of the name is incorrect i would have duplicate ids. Would it be possible to have only on id ?

I am not sure what you mean.
If you have typos, the values will be different, so they will be treated as different people.
I am not sure what you want to do about that, because if the values are different, how is Excel supposed to know the difference between different people and typos?

 

[capitano10]

i understand

would it be a way to filter the duplicats by the id from the column A?

 

[Joe4]

would it be a way to filter the duplicats by the id from the column A?

For what purpose?
What is it that you are ultimately trying to accomplish by doing this?

 

[capitano10]

i managed to hide the duplicates ids

Many thanks once again