Max of % nembers in column WITHOUT counting dates
 

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

Max of % nembers in column WITHOUT counting dates
 

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)

"dilettante" wrote in message
...
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

Max of % nembers in column WITHOUT counting dates
 

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

"dilettante" wrote:

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