Thread: [Solved] Exlude Blank Fields using MIN in an ARRAY
View Single Post
 
Old 04-11-2016, 01:42 PM
TomSv TomSv is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Apr 2016
Posts: 2
TomSv is on a distinguished road
Default Exlude Blank Fields using MIN in an ARRAY
=MIN(IF($A$2:$A$113>(TODAY()-90),(E2:E113))) Where column A contains dates and Column E contains values and blank cells.

=SMALL(IF($A$2:$A$113>(TODAY()-90),(E2:E113)),COUNTBLANK(E2:E113)+1) does not work either because I am counting all blank cells in column E, not just the last 90 days.
Reply With Quote