I have such a table
I need to filter this table and leave only POs (Purch. doc.) for which at least one Item (column F) is not with Conf Type (column A) so there is no AB
I marked on yellow those lines/PO
I need only POs number
You want only that row where AB is available . Is i am right ?
Thanks and regards
I need a list of POs where at least one line item is not confirmed, which means is not with AB
Can you provide expected out sheet ?
1.xlsx (11.2 KB)
You can see list of output I want