Can I Add A Quantity To Every Cell In A Column Using A Formula?

Hi
this is very dynamic requirement.
I have attached image as well sample sheet for what i need.

In brief:
I want to transfer(cut or moving) the cells to respective column but on same row from where is has been cut.

For example: (where , (comma) means different column

Account No.1
item33,quantity,amount,
item2,quantity,amount,
item48,quantity,amount,

Account No.2
item9,quantity,amount,

Account No.3
item19,quantity,amount,
item2,quantity,amount,
item6,quantity,amount,
item75,quantity,amount,
item52,quantity,amount,

Now i want put it like this

Account No.1 item33,quantity,amount,
Account No.1 item2,quantity,amount,
Account No.1 item48,quantity,amount,

Account No.2 item9,quantity,amount,

Account No.3 item19,quantity,amount,
Account No.3 item2,quantity,amount,
Account No.3 item6,quantity,amount,
Account No.3 item75,quantity,amount,
Account No.3 item52,quantity,amount,

I have also attached image and sample excel file.

Thanks

Hi everyone, I'm in need of some assistance.

I have a spreadsheet. In column A, I have a unique identifier number. In column B, I have a quantity. My problem is there are around ~600 duplicates. Ex:

ID | Quantity
23 | 4
23 | 8
24 | 4
25 | 4

I want to remove the extra ID, but sum the quantity value together, is this possible?
Ex (following from above):

ID | Quantity
23 | 12
24 | 4
25 | 4

Any help is appreciated. Thanks!

Hello!
I need some help please ....I need a formula that will calculate the quantity of each size of an item (XS,S,M,L,XL). For example to calculate the quantity for Mediums, I need the formula to look at column C, if M is entered, then look at the adjacent cell in column A for the quantity and formulate a total number (from rows 4-21) and enter the total quantity in C27.
See attachment.
Thanks for your help! Kim

in first cell (A1) i have a code: 553282300000
in second cell (B1) quantity: 50
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 160.

Here is the example:

Code........................Quantity

553282300000............... 50........................55
553290240040..............160........................58
553480480020..............420........................7E
553492300040............... 20
583182300060SMA.......100
585281100060SMA........ 80
7E1382300000................15
7E1682300000................38
7E3684000000................73
7E3684000002................57


What i have to do is to sum the quantity of the products that begin with 55 in "C1", quantity of the products that begin with 58 in "C2" and the quantity of products that begin with 7E in "C3".
Can someone help me?

Thank you!

I have a list of data.. I wish to make column "A" numbers random. Is there a way to do it?

ORIGINAL
1...keyboard....quantity 1
2...fan coil...quantity 4
3...mouse...quantity 2
4...staples...quantity 7
5...menu...quantity 3
6...thumbdrive...quantity 1
etc

RESULT
1...staples...quantity 7
2...thumbdrive...quantity 1
3...fan coil...quantity 4
4...mouse...quantity 2
5...keyboard....quantity 1
6...menu...quantity 3
etc

I have a huge amount of data which i would like to keep consistent.

In 1 cell i have a quantity and in another cell in a different column i have the quantity to date value. I know how to make it so the quantity to date cell does not exceed the planned quantity but is there a way of repeating this for hundreds of situations rather that data validate every single cell, just like if you were dragging a formula through a range of cells?

please help

in first cell (A1) i have a code: 553282300000
in second cell (B1) quantity: 50
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 160.

Here is the example:

Code........................Quantity

553282300000............... 50........................55
553290240040..............160........................58
553480480020..............420........................7E
553492300040............... 20
583182300060SMA.......100
585281100060SMA........ 80
7E1382300000................15
7E1682300000................38
7E3684000000................73
7E3684000002................57


What i have to do is to sum the quantity of the products that begin with 55 in "C1", quantity of the products that begin with 58 in "C2" and the quantity of products that begin with 7E in "C3".

NOTE: OP requires VBA solution - WF solution provided previously he related thread: http://www.excelforum.com/excel-work...st-column.html
(D.O)

Hello All,

I have a inventory question that I need help with.

Lets say cell:
A1=Quantity in stock (person enters)
B1=Quantity used per day (person enters)
C1=Quantity used per week (person enters)
D1=Reorder Level (Person enters)
E1=Status (Condition formula)

What I need formulas for are
1. Subtract quantity used per day(b1) or quantity used per week (C1) from quantity in stock (a1). Then I want the total of this (a1-b1 or c1) to replace the quantity in A1 as the new quantity in stock.

After the calculation is completed I am looking for a formula that then clears the cells (B1 or C1) for the next entry (the next day/week).

2. A status formula that will state when A1 (quantity stock) is above the reorder level (d1) the cell (e1) will be green and say In Stock, otherwise if a1 is less than or equal to d1 then state Need to order, and turn cell e1 yellow.

If anyone can help I would really appreciate it!!! I would even pay for your time invested if I need to!!

Thanks!!

Hi,

I'm working on some VBA to re-format some quotations to a more basic layout for data entry. The re-formatted sheet is very simple containing just the product code in column A and the quoted quantity in column B.

A colleague has asked me if the quantities could be ommitted but if the quantity is greater than 1 then it should duplicate the code underneath the original (duplicate once for a quantity of 2 or twice for a quantity of 3 and so on).

I'm not really even sure where to start with this - can anyone help?

Ok, so here's the situation:

I have one static cell, in this case it's "F48" and I need it to equal the sum that I have at the bottom of another range of data. That range of data always changes in the amount of rows, however the columns are static. In column "J" is the part number, column "K" is the description, column "L" is the quantity, and the only purpose of column "M" is to label the total quantity at the very bottom of the data where everythign is summed.

I can't simply just do a sum formula in the F48 cell because of how everything is arranged and how it changes. Basically, I just need code that looks for the term "Polarized" in column "M", and takes the total quantity that is in the cell directly to the left of it, and copy that quantity into F48.

Any ideas?

Help. What I need to do:

I have a spreadsheet with a list of products, quantity, descriptions, discounts, etc., used to prepare estimates and orders.

Each row is an item and information to configure item cost. I have an item quantity in column (A). I have a numerical Pts in column (L).

I have a reference table at the top with y value ranges (1, 2-5, 6-17, 18-47, etc), to select from the quantity in column A. The x values are number ranges (pts) (0-5000, 5001-10000, 10001-20000, over 20000.) to select from column L.

I need a formula for a cell in the same item row (J), determined by table value from quantity and points.

Summary: I have to enter a value used to determine pricing, which is based on quantity and stitch count for embroideries.

Help anyone?

Box Size (units that can be placed inside)
F G H I J K
Quantity 1 - 7
units 8 - 30 units 31 - 40 units 41 - 84 units >84 8 0 1 0 0 0 4 1 0 0 0 0 4 1 0 0 0 0 7 1 0 0 0 0 7 1 0 0 0 0 210 0 0 0 0 3 7 1 0 0 0 0 7 1 0 0 0 0 4 1 0 0 0 0 14 0 1 0 0 0 70 0 0 0 1 0

I have this table with me which follows the quantity and the units (boxes required) that is involved when it is within range

the formula for B=IF(AND(F2>0,F27,F230,F240,F284),F2/84,0)

Lets look at row 6 where the quantity is 210 and the box that is needed is 3.

What i want is that the quantity of the range higher than 84 is 2 and the rest is given to the columns that can take the quantity of the its balance
example= 210/84= 2.5 which equals to 2 box (that can fill 84 units each)
and 1 box that can fill 42 units which is the box @ column J.

How can i do this? what formula to use?
Please help me, Excel Guru

I am looking for a way to automate the goal seek tool in excell or write a formula to find the "Quantity 3" below.

I have a column of 100 items that are variable and to calculate them one at a time is way to slow

The feilds I am dealing with are

"Quantity 1" = $6760
"Sell Price 1" =$1,882

"Quantity 2" = $27,038
Sell Price 2 = $2,698

Goal Unit price =.10

"Quantity 3"= Goal Quantity that needs to be determined with a Goal seeker formula that will create a unit Price that matches a Goal Unit Price

"Sell Price 3"= Formula that interpolates from "Quantity 1", "Sell Price 1" and "Quantity 2", "Sell Price 2" using Qty 3 as its variable

"Unit price 3" = Formula = Sell Price 3/Quantity 3 (This needs to match the Goal Unit price

This is my 1st post, Thank you for any help

Jim

Anyone Who Can Help:

I have a formula that is much too long which takes into account the quantity of a product that potential customers could buy and the price of each product.

I know there is a way of shortening and condensing the formula I currently am using which is what I need.

The current formulas goes through 17 different product categories and then multiplies the price by the quantity.

I.E.-- sum((A1*B1),(D1*E1),.....) The "...." goes out for 17 different products on the sheet.
This is where A1 is the Quantity and B1 is the Price of the first product, D1 is the Quantity of the second product and E1 is the price of the second product.

Attached is the spreadsheet for easier explanation. The formula I'm searching for needs to be in column EJ.

Any help is appreciated.

I have 3 columns:
in first cell (A1) i have a code: 553482300040
in second cell (B1) quantity: 1000
and in third cell (C1) i have first 2 numbers from first cell (A1), in that case 55.
In second row, first cell (A2) i have another code, but begins with 55 too, in second cell (B2) i have quantity for this: 500.

What i have to do is to sum the quantity of the products in third cell, row 1 (A3).
Can someone help me?

Thank you!

Here's my situation, I've got over 1000 inventory items in a column with the Quantity of each in the column next to it. I'm trying to make it easy to find the item without scrolling through the list.

The item name and quantity are setup in two columns, column a and column b. I would like to have a cell where you enter the items name and once you hit return, it will take you to the the item in the column and then highlight the quantity.

My question is, would INDEX or MATCH be the best choice for this? In addition, what would the best formula be for such a thing.

I've got a problem that I've been trying to solve for most of the day. Let me try to lay it out for you.

If have my data arranged horizontally for ease of entry and I would like to sum certain cells if certain conditions are met.

DATA ARRANGEMENT
Column B: Customer Name
Column C: PO#
Column D: PO Date
Column E: Type
Column F: Total Quantity
Column G: Ship Date
Column H: Quantity to Ship
Column I: Ship Date
Column J: Quantity to Ship
Column K: Ship Date
Column L: Quantity to Ship
Column M: Ship Date
Column N: Quantity to Ship
Column O: Ship Date
Column P: Quantity to Ship
Column Q: Ship Date
Column R: Quantity to Ship

Columns G through R reflect the fact that multiple shipments are often made on one purchase order.

I would like to sum the values in columns H, J, L, N, P, R based on whether the Customer Name and Type in the row match the same values on another worksheet and based on whether the date to the left of Quantity falls within a given month.

The data on my reporting spreadsheet is arranged as follows:

Column A: Customer Name
Column D: Quantity (where the sum would be reported)
Cell A2: Type

I would like to end up with the quantity to be shipped in a given month for a given customer and type.

The thing that seems to be giving me the biggest problem is that one of the criteria is referring to a value that to the left of the numbers that I want to sum and therefore part of the Sum Range.

Please help!!!

Thanks!

I have a spreadsheet with a drop down list of items (column A), selecting an item in column A automatically fills the price in column C. In column B I want to put the quantity. Please can you help me with what formula I would need to use to put an automatic quantity of 1 in the quantity column if there is an item in column A selected, but if there is no item selected then a value of nothing should be returned, as in the box should be blank.

I have tried several if formulas to achieve this but none of them seem to work correctly.

Many thanks.

I have two columns as No.of persons & other quantity.Quantity is depend upon the following criteria. If the no of perons is between 1-4 the quantity will be 40, and if no.of person is betwenn 5-8 then 80 kg, if no of person increased from 8 then quantity 160kg. I applied the the formula =if(no

Hello All,

I have a inventory question that I need help with.

Lets say cell:
A1=Starting Quantity in stock (Person Enters)
B1=Quantity in stock (Formula)
C1=Quantity used per day (person enters, then calculates, then cell clears)
D1=Quantity used per week (person enters, then calculates, then clears)
E1=Reorder Level (Person enters)
F1=Status (Condition formula)


P/E=Person Enters



Starting Quantity



Quantity in Stock



Used Today



Used This Week



Reorder Level



Status



P/E
Formula
P/E then Clear
P/E then clear
P/E
Condition formula





What I need formulas for are
1. Subtract quantity used per day(b1) or quantity used per week (C1) from quantity in stock (b1). Then I want the total of this (a1-b1 or c1) to replace the quantity in b1 as the new quantity in stock.

After the calculation is completed I am looking for a formula that then clears the cells (B1 or C1) for the next entry (the next day/week).

2. A status formula that will state when b1 (quantity stock) is above the reorder level (d1) the cell (e1) will be green and say In Stock, otherwise if a1 is less than or equal to d1 then state Need to order, and turn cell e1 yellow.

If anyone can help I would really appreciate it!!! I would even pay for your time invested if I need to!!

Thanks!!