I am trying to find the minimum date in a column based on 2 criteria. It is similar to this formula;
=MIN(IF(D11:D1943=A1952,IF(E11:E1943=A1953,H11:H1943)))
but I would like to do it in vba code. What is the equivalent line in vba that achieves this?
I am trying this with defined ranges but vba does not have the if functionality?
Cell.Offset(0, 0) = WorksheetFunction.MIN(IF(AccountIDRng=Cell.Offset(0,-1),IF(SeriesRng=Cell.Offset(0,-2),DateRng)))"
Aucun commentaire:
Enregistrer un commentaire