ExcelBanter - =max(range includes #N/As)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =max(range includes #N/As) (https://www.excelbanter.com/excel-worksheet-functions/45310-%3Dmax-range-includes-n.html)

David

=max(range includes #N/As)

Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
--
David

Hi David,

Try...

=MAX(IF(ISNUMBER(YourRange),YourRange))

Array enter.

"David" wrote in message
...
Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
--
David

David

Thanks kk
--
David

"kk" wrote:

Hi David,

Try...

=MAX(IF(ISNUMBER(YourRange),YourRange))

Array enter.

"David" wrote in message
...
Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
--
David

Hi David,
You're welcome. Thanks for the feedback.

"David" wrote in message
...
Thanks kk
--
David

"kk" wrote:

Hi David,

Try...

=MAX(IF(ISNUMBER(YourRange),YourRange))

Array enter.

"David" wrote in message
...
Could anyone kindly suggest an arrray formula that will return the max
value
of non #N/A values in a range?
TIA
--
David

All times are GMT +1. The time now is 08:51 AM.