I just tested Frank's on my program and it works really well. You may want
to also use MAX & MIN.
=ROUND(MAX(--LEFT($K$8:$K$41,FIND("/",$K$8:$K$41)-1)),0) & "/"
&ROUND(MAX(--MID($K$8:$K$41,FIND("/",$K$8:$K$41)+1,10)),0)

Be sure to ARRAY enter.

However, I have a program (free for asking OFF LIST ONLY!!!) that separates
into
Systolic Diastolic Pulse
125 67 68
126 64 73
123 70 73

and then you can see the charts I made.
--
Don Guillett
SalesAid Software

"hjvn1302" wrote in message
...
I enter my blood pressure readings for the month in one column. Is there
a
formula to average them? i.e.
120/80
130/76
128/77
______
126/78 is avg
Thanks, Harry