|
|
#1
10-28-2013, 02:41 PM
|
|||
|
|||
Find MAX value in data containing '#N/A'
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. 
|
| Tags |
| #na, max() |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Word 2010 cannot find data source
|
wsdb | Mail Merge | 7 | 09-05-2012 03:16 PM |
|
Cannot find Outlook 2010 data files
|
COLC | Outlook | 4 | 08-09-2012 06:02 AM |
|
find data
|
GPENTEZ | Excel | 3 | 01-07-2012 03:41 PM |
|
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
|
How to write a macro to find a specified name in a list of data?
|
Jaffa | Excel | 1 | 10-23-2010 02:39 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode