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, 03:41 AM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Perhaps replace the countblanks part with

=COUNTIFS(A2:A113,">(TODAY()-90",E2:E113,"")

( hope the syntax is correct I prefer sumproduct)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« 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 09:03 AM.