quantity

In cell E19 I have a drop down list which has Pears, Apples and Bananas. In cell E20 I have the finish quantity and in cell E21 I have the start quantity. My questions are these: 1. Is it possible to use the same cells E20 and E21 for Pears, Apples and Bananas which have different quantities...

I am trying to get the sum quantity of the items both unique and duplicates but with only one output. I've attached my spreadsheet for review, but in case here is what I have. A B C ID Key Item Quantity Mickey wand 6 Minnie...

Hi, I would like to build simple excel file to be like POS in small Market. Attached is my file. In sheet1 there is barcode, products, price, Quantity and so on..The idea is that in sheet2, to the column A will be intered products barcode from scanner, and the other dates(product name, price...

I am trying to find the largest number based on the date, then quantity on trade for each day of the month. I currently do it manually each day but am looking for a formula to do it for me without using the ctrl+shift+enter function. Looking for the formula in largest trade column <tbody> Date...

Hi everyone, Question about conditional formatting. A have a dataset that is 6 columns of data, and I copy and paste the same 6 columns from a different data source right next to this, and then compare to see if there are differences. It works fine but where it is limited is that it is just...

Column A: Date (00/00/00) Column M: Reordered Quantity Looking for a formula for cell P2. The formula should count the values in column M (Reordered Quantity) if the corresponding date in Column A falls within the current month and year. Thanks!

I have an inventory spreadsheet formula with the following columns: Column A: Beginning Balance Column B: Quantity Received Column C: Quantity Issued Column D: Loss/Adjustment Column E: Ending Balance My formula in Column F would be: Beginning Balance + Quantity Received - Quantity Issued + or...

Hi everyone it is my first thread on this site I am stuck with an issue and I hope you can help here is the file attached basically it's about stocking products between 3 warehouses. warehouse1 warehouse2 warehouse3 stock of 42 references each warehouse contains rooms in which there must...

Hello Friends, I need a VBA code for worksheet change event for the following Cell B4: Show Quantity, Show Value or Show Value & Quantity Columns E,G & I Contains Quantity Columns F,H,& J Contains Value If cell B4 is set to Show Quantity Then Only Columns E,G & I should be shown if there...

Hello Friends, I am using the below code in my file... I would like to add second criteria in the code. Cell C3 has numbers Cell B4 has text (Show Quantity, Show Value, Show Quantity & Value) I want the code to trigger as soon as value in either cell changes. Any help would be appreciated...

On sheet1 I have product lists along with all the details and unique barcode. On sheet1 "barcode" column is "A" and "stock quantity" column is "E". On sheet2 "barcode" column will be "A" for scanning the barcodes and available "stock quantity" column will be "B". what I want is whenever I...

<tbody> Name Quantity Quantity sent Quantity left Bai Mu Dan 450KG 120 Calculation Formula in this cell Output calculation in this cell </tbody> Hi, Im wondering from what i have shown in the tabel above is possible. I want a calculation formula in cell D2 but want the...

Hi all, Can anyone assist with a vba solution to the below problem please. So I have from column I to column R columns labelled as follows: Job Desc 1 Quantity 1 Job Desc 2 Quantity 2 Job Desc 3 Quantity 3 Job Desc 4 Quantity 4 Job Desc 5 Quantity 5 What I need to do is, working from right...

Hello Everyone! really hope can assist on this. Have 2 large data sets across 2 worksheets. Want to lookup a quantity on 1 sheet that if equals same amount put ok in required cell . If not leave blank. so if a1 on sheet 1 is 100 and a1 on sheet 2 is 100 put ok. it would have to look up the...

Hi Mr.Excel.com Forum! I've learned so much from this forum but now I've got a question that I cannot seem to figure out. I am creating a spreadsheet that is serving as an invoice. There are two products (out of 20) that if the quantity of either one OR a combination of both add up to 3 or...

Hello, Does anybody know how I can calculate the quantity of shares in a sheet where the specific date isn’t there? The question is: what the holding positions (quantity of shares) would be for the following dates: 15th March 2003 14th March 2004 These dates are not in the actual sheet. Is...

I have an inventory spreadsheet where the supply item name is in Column D, Receipt Quantity in Column E, Issuance Quantity in Column F, Return Quantity in Column G, and Balance Quantity in Column N. What I would like to do is when I enter a supply item name in Column D and its balances, that...

Hi There I’m not exactly a new use of excel I use it for vlookupsetc. But I’m having a real hard time trying to convert some datainto a specific table. I start with three columns of data listed as follows: Part Number, Quantity, Date My table has the part numbers on the horizontal axis...

Hello, I have a list of part numbers that I want to subtractthe total quantity of based on a ranked used date. In my below table, I amusing a rank formula =1+SUMPRODUCT(($A$3:$A$7=A3)*($G$3:$G$7<G3)) But I don’t know how to subtract each used quantity inColumn D from the total in column C based...

Will someone please help me with writing of the code for a macro? I would like to run it on a newly opened document. Basically, I want the one column to use all of the rows which contain the same numbers, to give me a total of the corresponding rows' column. E.g A1,A2,A3,A9,A15 are the same (...