Remove duplicates replace with

[theboyscout]

I need to remove all duplicates and replace the value with a new value:

ID	Name
1234	BLUE
1234	BLUE
3456	GREEN
4567	YELLOW
3456	GREEN

<tbody>
</tbody>

What I'm looking in return is:

ID	Name
1234	MULTIPLE
3456	MULTIPLE
4567	YELLOW

<tbody>
</tbody>

Thank you in advance

 

[mrshl9898]

you could add column C

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

then pivot the data, id and new column in rows.