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

MO-118 0.8274% 1.3
MO-26 0.0012% 4.1

Jan 19 in Others 62 views

## 1 answer to this question.

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)))
```

• 58,640 points

## Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

## How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE