[Solved] Deleting duplicates, keeping lowest value in different column [closed]

by


You can add a column where you could check if PPFROM (the value) is the min of the group (ARTICLE).

Please adjust the references inside the formula.

enter image description here

This is the formula:

=IF(MINIFS($E$4:$E$10;$M$4:$M$10;M4)=E4;"Keep";"Delete")

After that you can filter by the new column and delete the rows marked with “Delete”.

solved Deleting duplicates, keeping lowest value in different column [closed]