quantity

I am trying to create one cell that shows the discount approval level required which varies by quantity. Thank you for your patience. So here is the matrix of what discount can be given at what quantity. The only require is to output a cell showing discount, which will then be conditionally...

Hi, can anyone help? I've created a Pivot Chart from my Pivot Table which has columns of :- Description, Invoice Quantity, Invoiced Amount and Net Profit. When I create the Pivot Chart it calculates the Invoice Quantity which is the first value in my Pivot criteria however I want the Chart to...

I want to make a table showing Item, Price, Quantity Sold and Total. I can set either column to ascending/descending without any issue and have that include the other columns. But i want to know if there is a way for it to show for example the highest total with the highest quantity? Is it...

I have a workbook with multiple tabs. On my Summary Tab I'm trying to calculate various averages from other tabs. Averageifs works great when the "Quantity" is 1 in a column from one of the tabs, but if it's greater than 1 it doesn't calculate properly. Data Tab <tbody> SPLC Qty. Job Hrs...

Hi Guys, I would like to create a stock list of items and need some help. What I'm looking to achieve is: Column A will have list of items, column B current quantity in stock & in column C should have input on quantity used. I need a formula or VBA code that will deduct B3 from B2 and then...

Hi All, I'm a total newbie , so please apologies for my poor language :) I need a macro that creates a pivot table in the existing worksheet (named C-grades). Range is O11:T500. Location pivot: 'C-grades'!$X$11 Fields to add to report: "material" (in rows) and "C-grade Quantity" (sum of...

Good evening everyone, I'm on a big excel project and I've run into another problem and I feel a little stumped. I'm have a table here that is pulling data from multiple sources. We will use the SGC-US Dividends example (AK:AQ) Column AQ is pulling the history of our trades with that stock...

Hi guys...just getting into excel. Loving it so far but keep hitting walls lol.. What im trying to do is this....... I want to be able to type in the size of material,then select gauge from a dropdown box then select the the quantity from another drop down box then excel to work a price out...

Hello, I am trying to set up a formula in a workbook to firstly highlight a range of cells between two given dates. Secondly I am trying to populate these cells based on start and finish dates and the quantity of resource for a given item. Duration Column J =((H49-G49)/5)+0.2 (Where 0.2 is 1...

Hello, My data contains three columns: 'Product 1', 'Product 2' and 'Quantity' - Quantity represents the number of times 'Product 1' and 'Product 2' were purchased together: <tbody> A B C 1 Product 1 Product 2 Quantity 2 A B 30 3 B A 30 4 C A 10 5 D C 5 6 E D 17 7 F A 11...

Hi All, I have two worksheets in a workbook (Sheet1& Sheet2) Need to validate the Invoice number& invoice amount and received quantity. In sheet1 Invoice amount in J column, Invoice number in L Column Received quantity is in S column. In sheet2 Invoice amount in K column, Invoice number...

Hello - I used index and match logic to lookup a SKU from a db of skus with 5 separate criteria. The only numbered criteria is rounding a whole number up to the next nearest whole number. I tried a -1 (see below, pulling off of C4) which works like a champ unless my quantity is 1, then it...

I am trying to populate an open order report with next production dates since our system does not peg production to orders. I am trying write a formula that will meet multiple criteria, but can't seem to get the formula to work just right. Below is a sample of the data and below that the...

I have been working on writing an if statement to lookup or index match values on another spreadsheet, but I have not been able to write something that will satisfy all of the criteria, therefore, looking for some help. I am trying to looking a production quantity on a separate tab, where value...

Can someone help me to solve this one, I want a formula that will return TRUE or FALSE only if all the following criteria will be met for this DATA. I want to check if all the data here below: <colgroup><col><col><col><col></colgroup><tbody> A B C Code Quantity Date 1 102 4 3/31/2018...

Dear Excel fellows: I want formula in Column C to E based on the percentage of column A on the quantity available in B, please help <colgroup><col width="184" style="width: 138pt; mso-width-source: userset; mso-width-alt: 6729;"> <col width="84" style="width: 63pt; mso-width-source: userset...

I am working in Microsoft Excel 2016 I have 26 sheets of data in a workbook representing weekly inventory part numbers and quantity (along with a bunch of other data regarding the parts). I am looking to find the highest volume part numbers and analyze trending part numbers over time. I am not...

I have 3 sheets with listed different models there you can indicated how many you need of which model (~300 models). I need to use a formula in another sheet that check these sheets and if cell is not blank (quantity indicated), return information to main sheet (order sheet) - name, barcode and...

Hi All, You helped me in the past - hope you can guide me this time as well :) Sorry I didnt know how to correctly title this post... My issue: In sheet 'one' I have a simple list of products with the price, etc. Column 'C' is for quantity ('ILOŚĆ') If I type specific quantity in the 'C'...

I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...