Quote:
Originally Posted by xor
I would use:
=MIN(IF(($A$2:$A$113>TODAY()-90)*($E$2:$E$113<>""),$E$2:$E$113))
It's an array formula so remember to hold down Ctrl and Shift before pressing Enter.
|
Perfect, thank you. I'm still not sure why it quits ignoring blanks when it's in an array, but that works.