Max of % nembers in column WITHOUT counting dates

D

dilettante

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
 
B

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)
 
B

bj

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