Forum Discussion
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?
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