Max of % nembers in column WITHOUT counting dates

[Guest]

I have a column containing dates (1/7/2006) and numbers (20%; 3%; ....)
I need in acell on the topo the maximum of the % of the column but I get
always the maximumof the "date" numeber.
Thank yoiu for helping
dilettante

 

[Bob Phillips]

Then change the column in the MAX formula to the column of the percentage
values. And format as %.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

try something like
=MAX(IF(A2:A400>1,0,A2:A400))
entered as an array formula (Shift-Control-enter)