I have a multiconditional formula which finds the earliest date of all
entries where all these conditions are met. If an entry does not consist of
all these conditions, I just want the cell left blank. How do I do that? I
have tried putting ,"" at the end of the formula but it still doesnt work.
Any help will be greatly appreciated.
MIN(IF((report!$D$2:$D$3001=$A$3)*(report!$I$2:$I$ 3001=$A$11)*
(report!$J$2:$J$3001=$A14)*(report!$K$2:$K$3001=$A 15)*
(report!$B$2:$B$30010),report!$B$2:$B$3001))