0

Allunique with two keys

I have this formula:
=IF($G23="";0;NL("sum";"Prod. Order Capacity Need";"Allocated Time";"Type";"Machine Center";"No.";G23;"Date";=NL("Datefilter";;"..12.08.12");"Status";"Released";"Starting Date-Time";"01.01.1900..";"Allocated Time";"<>0"))G23 = =NF($F23;"No.")F23 = =NL("Rows";"Machine Center";)
The problems is that this gives me prod.ordre routing lines with all statuses(?) . How can I filter out all operations with status "Finished"?

9 comments

Please sign in to leave a comment.