[Dba-office] Min function to ignore blanks

John Bartow jbartow at winhaven.net
Fri Aug 18 15:57:12 CDT 2017

I actually meant MIN()

It was not. I used the help and it said MIN() evaluates blanks as zero and returns zero.

But now that I've gotten frustrated and sent this message, I reopened it and it works just fine. <arg>

-----Original Message-----
From: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, August 18, 2017 2:45 PM
To: dba-office at databaseadvisors.com
Subject: Re: [Dba-office] Max function ignoring blanks

Is it not working as expected? 

Susan H. 

Hi All,
I need some assistance to get the Excel AX function to determine the maximum value in a row of cells not including the blank cells.

All help appreciated.
John B

Dba-office mailing list
Dba-office at databaseadvisors.com

More information about the Dba-office mailing list