Hi All,
I'm using a MIN formula to find the oldest date in a date range, but I'd like it to ignore "01/01/1900 00:00" and pick the oldest proper date.
The formula I'm using now is =MIN(Sheet1!k2:K10000)
Thanks
Jake
Hi All,
I'm using a MIN formula to find the oldest date in a date range, but I'd like it to ignore "01/01/1900 00:00" and pick the oldest proper date.
The formula I'm using now is =MIN(Sheet1!k2:K10000)
Thanks
Jake
Modify the formula as following:
=MIN(IF(Sheet1!K2:K10000>1,Sheet1!K2:K10000))
array entered, to be confirmed by pressing CTRL+SHIFT+ENTER
=MIN(IF(Sheet1!K2:K10000<>0,Sheet1!K2:K10000))
Array formula, use Ctrl-Shift-Enter
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perfect, thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks