Thread: [Solved] Find MAX value in data containing '#N/A'
View Single Post
 
Old 10-28-2013, 02:41 PM
Steve_B Steve_B is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Jul 2013
Posts: 7
Steve_B is on a distinguished road
Wink 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.
Reply With Quote