Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Please may you assist me with the below:
<o
></o
>
I have an excel 2003 spreadsheet with two worksheets.
<o
></o
>
Worksheet 1 has data (simplified):
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1:country-region w:st="on">Col.</st1:country-region> C <st1:City w:st="on">Product</st1:City>, <st1:country-region w:st="on">Col.</st1:country-region> I Cost, <st1:country-region w:st="on">Col.</st1:country-region> M Sale Price, <st1
lace w:st="on"><st1:country-region w:st="on">Col.</st1:country-region></st1
lace> P Gross Profit
Apple 10 10 0
Pear 10 20 10
Orange 10 25 15
Pear 15 15 0
Apple 10 17 7
Apple 15 20 5
<o
></o
>
What I am trying to create is Worksheet 2 which will analyse the data in Worksheet 1 to give some basic profitability figures and to inform purchasing.
As it stands Worksheet 2 is set out as:
<st1:country-region w:st="on">Col.</st1:country-region> A Product, <st1:country-region w:st="on">Col.</st1:country-region> B Total Sold, <st1:State w:st="on"><st1
lace w:st="on">Col</st1
lace></st1:State> C. Total Purchase Price, Col. C Avg Purchase Price, <st1:country-region w:st="on"><st1
lace w:st="on">Col.</st1
lace></st1:country-region> D Total Profit, Col. E Avg Profit
<o
></o
>
I am trying to get the formula’s to achieve the below
e.g Apple, 3, 35, 11.67, 12, 4
<o
></o
>
I have tried lookup functions but I am really struggling and would be very grateful of any assistance.
<o
></o
>
Thank you
<o
></o
>
Matthew
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Please may you assist me with the below:
<o


I have an excel 2003 spreadsheet with two worksheets.
<o


Worksheet 1 has data (simplified):
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com



Apple 10 10 0
Pear 10 20 10
Orange 10 25 15
Pear 15 15 0
Apple 10 17 7
Apple 15 20 5
<o


What I am trying to create is Worksheet 2 which will analyse the data in Worksheet 1 to give some basic profitability figures and to inform purchasing.
As it stands Worksheet 2 is set out as:
<st1:country-region w:st="on">Col.</st1:country-region> A Product, <st1:country-region w:st="on">Col.</st1:country-region> B Total Sold, <st1:State w:st="on"><st1




<o


I am trying to get the formula’s to achieve the below
e.g Apple, 3, 35, 11.67, 12, 4
<o


I have tried lookup functions but I am really struggling and would be very grateful of any assistance.
<o


Thank you
<o


Matthew