buys

Hi, I got a worksheet "Data", in column A I have the names of customers. In column B I have the sku´s and product name for each product that customer buys and in C I have the sum for each product. I have a sheet "summary" where all the customer names are listed (with no space between them)...

Hi! So far I was just a still follower, now i have problem where my mind currently is blocked. What I want to do: I'm building currently a business case for our startup. My timescale is monthly (C2 = Jan2018, D2 = Feb 2018.... What i need to simulate is: If we onboard a new customer in...

Hello Everyone! I'm about to join a company that sells retail products through its stores. Hence, they should have data available on their customers shopping quite easily. For Example: The billing data shows that a customer buys soap, shampoo and potatoes; another buys shampoo, soap and...

I have a column of dates and a column of actions (buy and sell). I need to be able to count how many buys or sells there were on each individual day. I have part of of the formula as Countif(B2:B1000,"Buy"). I need to know how to add onto this to be able to count the buys on say 1/1/2017...