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, 2023 in Others by Kithuzzz
• 38,010 points
244 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, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

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

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

answered Feb 11, 2023 in Others by Kithuzzz
• 38,010 points
653 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
• 63,420 points
528 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
• 63,420 points
619 views
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
• 63,420 points
486 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,670 points
1,073 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,670 points
1,354 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,670 points
662 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
• 23,260 points
2,196 views
0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

answered Feb 4, 2023 in Others by narikkadan
• 63,420 points
233 views
0 votes
1 answer

Highlight cells in an Excel column if the value can be found in an array

Try this: =COUNTIFS(B:E,$A1) READ MORE

answered Feb 24, 2023 in Others by narikkadan
• 63,420 points
803 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