P Peo Sjoblom Apr 18, 2004 #2 =MAX(Labels) check accept labels in formulas under tools>options>calculations
B Bernard Liengme Apr 18, 2004 #3 HI Sharon, Peo has given you the exact answer but I am wondering if you know the difference between 'labels' and 'range names' Select B13:E13 and type a name in the name box (to left of Formula Box) , a name such as Apple In F1 enter =MAX(apple) Best wishes
HI Sharon, Peo has given you the exact answer but I am wondering if you know the difference between 'labels' and 'range names' Select B13:E13 and type a name in the name box (to left of Formula Box) , a name such as Apple In F1 enter =MAX(apple) Best wishes
