Find maximum value in list that contains #N/A values

C

chuck.waterfield

I've really been struggling with this, and can't find any previous
posts on this topic. I have a column of numbers, some of which return
#N/A values, eg.

5
3
12
#N/A
11

I need to find the maximum value in the list while excluding the #N/A
value. Everything I try, returns an #N/A value, eg, MAX(list),
DMAX(list,criteria), LARGE(list). I've tried some array formulas, but
none that work...

Any ideas?

Chuck Waterfield
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning #N/A ?? 3
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Type Mismatch Error on IF conditional 3
Parsing an excel doc to find max values 0
MATCH returning #N/A 3
Knapsack Problem 1
Using ISNA on more than one column within an If Function 2
Find the maximum value in a row or column with text and numbers 2

Top