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.

Perhaps following array formula Commit with Ctrl+Shift+Enter

__________________
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

Thank you, Pecoflyer. Your solution is exactly what I needed. You are indeed an expert.

If your using Excel 2010 as in your profile, why don't you use the AGGREGATE function (Non array) and assuming your data is in column A!

=AGGREGATE(4,6,A:A)