quantities

Hi all I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered. I need some help please with what formula to use so that on a new fourth tab...

I have three quantities with prices: 30 - $6,313 100 - $5,592 300 - $5,261 I am trying to determine the price for each quantity in between the quantities above (31, 32, 33, 34, 35 etc). Honestly I am completely stuck and any help is greatly appreciated. Thanks!

Hi, I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities. Thanks in advance. Regards, Hiten

I am building excel sheets to simplify my life with co-management that are not "EXCEL SAVVY". I came across a dilemma that made me feel like the un-savvy employee in this matter. For scheduling production needs i am using this formula to manage capacities of storage so i can reference this cell...

OK, Let's try this again. I hope this makes more sense and look forward to see some responses if this is at all possible. I currently do all of this manually for a project that will be going on over the next 18 months. On the Due Day in column B, I would like to see the quantities in column A...

hi guys First time here! I have text data in a cell e.g. "Quantities: 2" or "Quantities: 3" etc. I want to be able to sum the fact that total quantity is 5 and I would normally do this by using text to column feature (fixed width) however is there a way I can extract or move just the number...

Hello, I am trying to aggregate weekly quantities into monthly ones. THIS LINK shows the dataset in question, the formula I created to aggregate these subsets, and the organization tactic I used. Is there any way I can make this formula dynamic? I feel like there is an easier way to do this...

Thanks you in advanced. I have a cell (say G11) which contains the following: 2+12+55+1+0+16+555+1= I need to extract all the numbers (automatically, with a formula or VB) into different cells keeping each quantity in it's own cell, for example: 2 will be in it's own cell 12 will be in it's...

Hello, I'm trying to create a pivot using two data sources for the first time. I'm familiar with one-source pivots. In the same workbook, I have two worksheets which have inventory quantities by inventory part number. I am trying to make a comparison of the two. I followed the steps from...

Hi all, I sure this will be an easy task for an expert.... C3:C30 contains prices D3:D30 contains a name F3:AH30 contain quantities For example, row 3 has a name "Ken" in column C, a cost of £2.00 in column D and a varying number of quantities in columns F:AH. I would like to multiply the...

Hello, I thought this would be simple to do but I am stumped by it so hoping someone can help me. I have a line chart with months on the x axis and the quantities on the y axis. All I want to do is have months on the Y axis and quantities of the x axis but just can't work out how. If Itry...

Hi guys, im new here and have a question. I have a table with 14 colums. In colum D are costumer numbers. I want to check with a VBA if a costumer number inside more than one time. In colum C are order quantities. If the costume numer dublicate i want to sum all of the order quantities from...

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...

Hello All, I'm new here, so please forgive my naivety. I've watched dozens of videos in an effort to resolve my issue, with no luck. So, I'm reaching out to the experts. Issue: I work for a printing company. We want to group art across the paper based on label quantities in the most efficient...