Excel Formula

[hrayani]

Hello Friends,

I want the below formula to be modified to the below condition

There might be more than one "orders_ref" so I want the formula to not to consider "orders_ref" if against any one "orders_ref" the condition is met
& if the condition is not met against all the "orders_ref" only then it should consider

=IFERROR(AGGREGATE(15,6,orders_ref/(((dpi_target_date<>"")*(dpi_actual_date=""))*ISNA(MATCH(orders_ref,B$57:B57,0))),1),"")

Regards,

Humayun

 

[plettieri]

you might try this...maybe using Countifs would help

=IFERROR(AGGREGATE(15,6,orders_ref/((dpi_target_date<>"")*(dpi_actual_date="")*(COUNTIFS(orders_ref, orders_ref, dpi_target_date<>"", dpi_actual_date<>"")=0)*ISNA(MATCH(orders_ref,B$57:B57,0))),1),"")

plettieri