|
|
#1
04-11-2016, 01:42 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 looking to persist and array or something
|
vthomeschoolmom | Word VBA | 1 | 09-16-2015 02:12 PM |
| Array to iterate through variables and trap blank variables | Marrick13 | Word VBA | 5 | 08-04-2015 06:19 AM |
|
Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
|
Form Fields - Create blank form text field with if statement?
|
LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |
|
How to turn all blank lines into non-blank for legal forms
|
sieler | Word | 3 | 04-12-2009 01:38 PM |
Windows 7 64bit 
Office 2013
Threaded Mode