I tried this on a dummy i made:
=MIN(IF((D1:D4>=A1)*(D1:D4<=B1),D1:D4,FALSE))
and got the good old "#VALUE" error result...
I tried this on a dummy i made:
=MIN(IF((D1:D4>=A1)*(D1:D4<=B1),D1:D4,FALSE))
and got the good old "#VALUE" error result...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks