I am having problems putting this into words, so bear with me.
I am attempting to find the Median which I normally know how to do. The problem is something else. I have 4 columns
Sales Person
Product
# of Products Sold
Price
I want to find the Median price of products sold for each Sales person. The problem comes when they have sold more then one of a product. My current list is 3600+ rows long otherwise I would manually add all the products in. I have tried pasting in an example below. The only way I can think to do it is to manually add in a cell for each and every product sold. Ex. Row 1, I would add in $27 again. Same for Row 2. Row 4 would have me add 5 additional cells containing $38.00. Can anyone help?
<tbody>
</tbody>
Rollie Wright
I am attempting to find the Median which I normally know how to do. The problem is something else. I have 4 columns
Sales Person
Product
# of Products Sold
Price
I want to find the Median price of products sold for each Sales person. The problem comes when they have sold more then one of a product. My current list is 3600+ rows long otherwise I would manually add all the products in. I have tried pasting in an example below. The only way I can think to do it is to manually add in a cell for each and every product sold. Ex. Row 1, I would add in $27 again. Same for Row 2. Row 4 would have me add 5 additional cells containing $38.00. Can anyone help?
Sales Person | Product Code | No Of Bottles | Price |
Bob | A166 | 2 | $27.00 |
Bob | A166 | 2 | $27.00 |
Bob | A4990 | 2 | $38.00 |
Bob | A4990 | 6 | $38.00 |
Bob | B1192 | 1 | $21.00 |
Bob | B3053 | 2 | $45.00 |
Bob | B3053 | 2 | $45.00 |
Bob | B3053 | 6 | $45.00 |
<tbody>
</tbody>
Rollie Wright