jeudi 19 mars 2015

Minimum Value in range based on 2 critiria vba excel

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