Excel TD and two filters

Hi all,

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
EXAMPLE.xlsx (11.1 KB)

Hi ,

You want only that row where AB is available . Is i am right ?

Thanks and regards
Sahil Garg

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