$$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

Hi experts! I have a project to do given to me by a doctor that has a series of blood pressure results (numbers) from various patients. And would like me to give him the average blood pressure result. How can I get Excel 2007 to convert the 120/80 into a format that will allow me to find

Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

see if it helps On Sun, Mar 27, 2011 at 10:58 PM, Susan sunni...@gmail.com wrote: Hi experts! I have a project to do given to me by a doctor that has a series of blood pressure results (numbers) from various patients. And would like me to give him the average blood pressure result.

Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

please try this Array formula =ROUND(AVERAGE(--LEFT(A1:A3,3)),0)/ROUND(AVERAGE(--RIGHT(A1:A3,2)),0) Array Formula needs to be entered with 3 keys : Ctrl + Shift, Enter ! On Mon, Mar 28, 2011 at 12:28 AM, Susan sunni...@gmail.com wrote: Hi experts! I have a project to do given to me by a

RE: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

Yes that works great! ~S From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Sunday, March 27, 2011 6:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that