Hey there,
I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work?
=IFERROR(INDEX(Number; MATCH(0; COUNTIF(F$14:$F14;Number)+IF(Priority<>$C$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "")
I want the selectedcustomer to...