G
Gwynneth
I am trying to find the minimum date in a range, which contains blanks.
subject to a criteria. As the range contains blanks, these are currently
picked up as the min date and display 00-Jan-00.
Is there a way of using sumproduct and excluding/ignoring blank cells?
PO1 is my range for criteria and Created1 is my range on the dates I am
using in the following formula
=Sumproduct(MIN(--(PO1=A2)*Created1))
Gwynneth
subject to a criteria. As the range contains blanks, these are currently
picked up as the min date and display 00-Jan-00.
Is there a way of using sumproduct and excluding/ignoring blank cells?
PO1 is my range for criteria and Created1 is my range on the dates I am
using in the following formula
=Sumproduct(MIN(--(PO1=A2)*Created1))
Gwynneth