I need to filter the table.
Im looking at column Putch.doc. The goal is to remove duplicate PO numbers and leave only single PO number, but additionally I have to look at column Conf Type and if I have several lines for one PO number once with Conf Type ‘AB’ and once without I have to keep the line where Conf type is empty.
and what I want to leave
Excel file with input and expected output
1.xlsx (12.3 KB)