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
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Please may you assist me with the below:
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I have an excel 2003 spreadsheet with two worksheets.
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Worksheet 1 has data (simplified):
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
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
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
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
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I am trying to get the formula’s to achieve the below
e.g Apple, 3, 35, 11.67, 12, 4
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I have tried lookup functions but I am really struggling and would be very grateful of any assistance.
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Thank you
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Matthew