quantities

  1. J

    Summarize 3 Tabs into 1

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

    Trying to Create a Pricing Curve

    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!
  3. H

    Formula to order an item based on sales and quantity on hand

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

    Sumif filtered criteria

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

    Data to appear when between 2 dates - Round 2

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

    remove specific content of a cell to a new cell

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

    Create dynamic monthly quantities from weekly quantities for multiple data items?

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

    Extract numbers from a cell keeping the quantities together

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

    Two Data Source Pivot Returning Field Total Sum Instead of Individual Values

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

    Sumproduct? multiple columns with a criteria

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

    Changing Line Graph Format

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

    find duplicates in a column and sum

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

    Conditional Pricing Formula

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

    Grouping Challenge!

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top