Forum Discussion

RahulSomani5's avatar
RahulSomani5
Copper Contributor
Feb 10, 2026

Remove duplicates with other cell reference

how to remov duplicates from a column, where the sum of the duplicate item is lower in another column?

excel
Formulas and Functions

1 Reply

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Feb 11, 2026

    HelloRahulSomani5​, 
    To remove duplicates and keep the row with the highest value in another column Excel 365 or 2021 use the formula =FILTER(A2:B5, B2:B5=MAXIFS(B2:B5, A2:A5, A2:A5)) This keeps only the rows where each item has the maximum value Older Excel versions add a helper column with =MAX(IF($A$2:$A$5=A2,$B$2:$B$5)) Enter as an array formula using Ctrl+Shift+Enter Then filter where Value equals the helper column and keep those rows Alternatively in any version you can use Power Query load the table Group by Item and take the Max of Value