purchased

I am wrecking my brain over what formula to use to summarize data (into a chart) using the data tab. Below on the Summary tab I would like to know how many Fruit, total AND individual, do I want and how many I've purchased for each date. As time passes, I will change the date in Row 2 and I...

Customer produces and sells widgets (CW). We sell a report about the performance of the widgets. I have a spreadsheet of customers with one report sale per row - Customer Name in Column A, Product Name in Column B, other data (irrelevant to my question) in other columns. Customer may have...

Hi All, Going to do my best to explain what I’m looking for here :-). So I’ve created a table that calculates a quantity of an item (eg the amount of pipe required for a project by room) this results in a range of pipe lengths. What I’m hoping for is a formula to group the data (as efficiently...

Hi Guys, Been a while. Got one that I cant quite get right in my head how to do it. I have a list of clients and the products they have purchased. Client table: <tbody> Client Name Products Users Fee Mr PROD1 5 100 Mr PROD2 1 100 Mr PROD3 3 100 Excel PROD1 5 100 </tbody>...

I swear this has to be easy but I'm not figuring this out. I've looked at VLOOKUP, Index & Match, Pivot Tables, etc. I've got a table with 65k rows. In one column, I have a customerID, in another column I have an item purchased. I have many other columns, but I want to be able to find...

Hi, I have a data set that has a number of customers. Some of those customers have partners/spouses, and I need to focus on "households" where the person to be focused on is the one who has, in order: 1) spent the most or 2) if the same was spent, then the one who purchased the most. The way...

Hi all, New to the forum and just beginning to learn VBA. I'm trying to streamline a process in my work where we create a folder with the following format; ORDER ID / ACCOUNT NUMBER / ITEM BEING PURCHASED Is there a way to code this in which I will just click a button on the sheet, input...

Hi, I have a trouble in Excel as mentioned below please help us to solve the issue. I have 2 workbooks one is "Entry Sheet" other is "Master Data Sheet" Entry sheet column A is "Product Name" B is Purchased Qty c is Purchased Date Currently i using sum if & Vlookup formula in Master sheet to...

Good day, Is there a way to set up a security on a spreadsheet to be sold to multiple persons to prevent it being resold to those who did not pay.? I was thinking a unique security feature for each spreadsheet purchased. Thanks,

Dear Excel Wizards, Current Scenario Product Price : $50 Quantity : 10 Revenue : $50*10 = $500 However, how do I create a separate row denoting a promotion that shows that the buyer is only paying for 9 quantities for every 10 purchased. This will increase across the columns based on...

I have a spread sheet with several columns: <tbody> Date Purchased Item Mint Year Type Metal Oz </tbody> The entries have 3 different Types: Coin, Ingot and Round. I want a formula that will query the entire table and show me how many coins I have. How can I do this? I'm wanting to show the...

HI, I have one workbook with 8 spreadsheets on it. 7 sheets refers to the days of the week and the 8th one is for the calculations. On each sheet I have: Column A with names of 5 buyers represented by numbers from 1 to 5; Column B with 10 products represented by numbers from 1 to 10 ; Column C...