Excel If duplicate agree paste the value

Question

Could you kindly assist me with this calculation in Excel?

I have a table with duplicate values; if the duplicate values agree, I want to replicate the value; otherwise, I want to copy the value itself.

Input

Name	M1	M2
MO-118	0.8274%	1.3
MO-118	0.8274%	1.3
MO-26	0.0012%	4.1
MO-26	0

Output

Name	header 2	M2
MO-118	0.8274%	1.3
MO-26	0.0012%	4.1

Answer 1

With Office 365:

=LET(
    nm,A2:A5,
    m_1,B2:B5,
    M_2,C2:C5,
    unq,UNIQUE(nm),
    HSTACK(unq,MAXIFS(m_1,nm,unq),MAXIFS(M_2,nm,unq)))