Excel If duplicate agree paste the value

0 votes

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

Jan 19 in Others by Kithuzzz
• 27,740 points
36 views

1 answer to this question.

0 votes

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

enter image description here

answered Jan 19 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

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

answered Oct 24, 2022 in Others by narikkadan
• 51,240 points
138 views
0 votes
1 answer
0 votes
1 answer

Excel delete row if column contains value from to-remove-list

Given sheet 2: ColumnA ------- apple orange You can flag the rows ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 51,240 points
225 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 51,240 points
381 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
205 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
364 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,640 points
165 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
144 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 51,240 points
155 views
0 votes
1 answer

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 51,240 points
170 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP