[Dba-office] Min function to ignore blanks

[John Bartow]

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
http://databaseadvisors.com/mailman/listinfo/dba-office