Excel Min If.JPG
I need help with this formula. It works great except, I don’t want it to include the current months numbers, in this case Jan 15 as it is a dynamic number. I would like the formula to step through all the cells looking for the MIN, ignoring the #NA and any numbers in the current month.
I suspect it would be something along the lines of {=MIN(IF(DATE(TODAY(MM)-1(ISNA(B3:Y3))),B3:Y3))}
And entered as an array {}
I’ve tried some seriously whacked combinations and can’t quite get it to ignore the current month and actually work.
TIA
-Ray
Bookmarks