![]() |
#1
|
|||
|
|||
![]()
Need a way to find the max value in data that may contain the error value '#N/A' instead of a numeric value. MAX() will return #N/A if it encounters it anywhere in the data being queried. It can't be that hard. Well, you would think not. Using Excel 2010.
Last edited by Steve_B; 10-28-2013 at 03:45 PM. |
#2
|
||||
|
||||
![]()
Perhaps following array formula
Code:
=MAX(IF(NOT(ISNA($A$1:$A$50)),($A$1:$A$50)))
__________________
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 |
#3
|
|||
|
|||
![]()
Thank you, Pecoflyer. Your solution is exactly what I needed. You are indeed an expert.
|
#4
|
|||
|
|||
![]() Quote:
=AGGREGATE(4,6,A:A) |
![]() |
Tags |
#na, max() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wsdb | Mail Merge | 7 | 09-05-2012 03:16 PM |
![]() |
COLC | Outlook | 4 | 08-09-2012 06:02 AM |
![]() |
GPENTEZ | Excel | 3 | 01-07-2012 03:41 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
Jaffa | Excel | 1 | 10-23-2010 02:39 PM |