bought

Hi all, I need to solve a problem of dividing whole numbers in excel based on these variable: Company AA can only sale to company A and the quantity bought and sold is always the same. In this example 44 000. Company A1 can receive 6000 from AA1 and 9000 from AA2 or 15000 from AA1, etc. That...

:confused: I have a fully functioning Excel 2007 spreadsheet with a few macros and VBA code utilised to achieve a result. A couple of days ago, I bought a new laptop and also bought Office 365 to install. I have done the installation of the Office application and now my macros/VBA are having...

Hi, I need some help with Excel to calculate ROI for this situation: <tbody> date quantity price bought quantity price sold ROI 2015-09-05 4,000 3.16 2015-11-05 1,500 3.56 2016-07-08 2,000 4.13 2016-11-10 2,000 4.51 2017-01-05 1,000 4.12...

Hi all I have an Excel file as attached which show months in which we have order from customers. Could you please help me the formula to show the month in which the customer first bought our product? I have attached both the Excel file and an example picture. Thank File...

Hello all, This is my first on this forum although I come here quite often to seek solutions. Now I think I've stumbled upon something that has not been yet touched or maybe has been but I was unable to find it. I have a following problem. I need to got though a list of customers and make a...

Hi, I have a list that contains many names of products (about 20k). I need to input the status (three options: bought, sold, expired). <colgroup><col span="2"></colgroup><tbody> A Name B Status Apple Orange Pineapple </tbody> I also have a list of bought, sold and expired items that...

I have stock buy/sell transactions and want to calculate my position. Here is some sample data: I can calculate most things I need but I'm struggling with Average Cost. So XXX bought 100 at $1 then sold 50 at $2, so my average cost is $1. Then bought 100 at $2 and sold 100 at $3 so I have a...

Hello, I'm trying to establish which two products are frequently bought together. I have the data in the below format: <tbody> Product(s) Apple Banana Orange Pear Apple 0 0 0 5 Banana 0 10 0 0 Orange 12 0 0 0 Pear 0 0 6 0 </tbody> So in the above, 12 customer's bought an Orange and...

i buy and sell 4 items no more, the problem is the items prices changes everytime i buy it. let's say one of the items is a "sugar" ... i bought it yesterday for 1$ for 1kilo and i bought 50, then after a week 2$ for 1 kilo and i bought 50 etc... when i sell 30, it costs me 30$ cuz it came from...

Hi, I have a table like below. I have a formula in another sheet that lets me know how many apples Bob bought on day 1 - it works great: =SUMIFS(Sheet2!C:C,Sheet2!A:A,"Bob",Sheet2!B:B,"Apples") BUT I need excel to sum the "month to date" as well to see how many apples Bob has bought so far...

I have a report that has the customer name at the top then below it items they bought and then an empty row, another customer and items they bought. I need to move the customer name to column A so it's in the same row as the item number. I have about 550 customers in this report. How can I do...

I would like to create a pie graph that shows the frequency of the number of times a customer has bought, e.g. how many bought 1 time, how many bought 2 times, etc. The raw information looks like this: The total orders is a calculated measure: Customer Total Orders =...

Hi I hope you can help as this is driving me crazy <tbody> https://1drv.ms/i/s!AltSK4V_VD03iGo9OswyEYs850Ib Above is a link to a screenshot of part of my worksheet. I am trying to calculate the total cost of beverages bought for a till type sheet. So The drinks are populated from named...