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-12-2016, 05:08 AM

xor

Windows 10 Exlude Blank Fields using MIN in an ARRAY

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

I would use:

=MIN(IF(($A$2:$A$113>TODAY()-90)*($E$2:$E$113<>""),$E$2:$E$113))

It's an array formula so remember to hold down Ctrl and Shift before pressing Enter.

« 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 10:49 PM.