Exclude non numbers from list

  • Thread starter Thread starter nuo
  • Start date Start date
N

nuo

Hi,

Greatly appreciate anyone who can help me on this.

I have a list, say (54%, 20.8%,#NA,60%,30%,48.3%) from A1 to A6.
would like to do a max on the data, call the highest percentage fro
the list.

I did a =max(A1:A6) but result is #NA . What can I do?

Thanks!
 
Hi,

Greatly appreciate anyone who can help me on this.

I have a list, say (54%, 20.8%,#NA,60%,30%,48.3%) from A1 to A6. I
would like to do a max on the data, call the highest percentage from
the list.

I did a =max(A1:A6) but result is #NA . What can I do?

Thanks!
j
Click to expand...
Hi,

try,

=MAX(IF(ISNUMBER(A1:A6),A1:A6)), which is entered using ctrl + shift + enter

Hope this helps!
 
Hello,
Sorry I am of no help but have to let you know,that I have typed you
data and got a 60% as maximum!?
I can see the other person's reply to you where he creates an arra
formula sifting out all non numbers before performing: max

Regards,

Gabo
 
Hi Domenic,

may i know why you would hit enter by "Ctrl+Shift+Enter"?

Really Appreciate your help!!

Regards
 
Hi Domenic,

may i know why you would hit enter by "Ctrl+Shift+Enter"?

Really Appreciate your help!!

Regards
Click to expand...

I'm no expert, but according to the definition in the help menu, "array
formulas perform multiple calculations and return either a single result or
multiple results". As such, array formulas need to be entered using
Ctrl+Shift+Enter. More information is available in the help menu, although
not much.
 
Back
Top