Exlude Blank Fields using MIN in an ARRAY

		Microsoft Office Forums > Microsoft Excel > Excel
Exlude Blank Fields using MIN in an ARRAY

FAQ

Thread Tools

Display Modes

04-11-2016, 01:42 PM

TomSv

Windows 7 64bit Exlude Blank Fields using MIN in an ARRAY

Office 2013

Novice

Join Date: Apr 2016

Posts: 2

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:23 PM.