volume

Hi guys, I have faced a problem I hope you can help me with :) I need to track on which date does a certain product reached a certain volume of sales: 500 units, 1000 units, 2000 units <tbody> Product Volume reached 500 2000 etc A 100 date date B 500 date date C...

Hi all, I'm trying to copy data and reformat it from one sheet to another and running into some problems. (Note: the row/column numbers are different on my actual sheets) I have Sheet1 setup as follows: <tbody> A B C D 1 WK1 WK2 WK3 2 Product 1 3 Value £5787 £1211 £4431 4 Volume...

Hello, I have a worksheet that contains hyperlinks to hundreds of documents (Column B). The text string for hyperlinks under Column B contains volume and page numbers that I would like to extract and place in Column E. (1) What formula would I need to extract the number after volume? (2) What...

New user here in need of help. I am creating a mixture design using 3rd party software and needhelp setting up the constraints. I’m using Excel to do the math and willput it into DOE software. What the DOE softwaredoes is it looks at the high and low ranges that you enter, and it...

Hi I'm trying to figure out a way I can actualise some data so this is the only place to come. 1) I have forecast Sales, Forecast volume and Net Invoice value (NIV) in one table. The data is granular in that it shows the sales ID an product code. 2) In another table, I am pulling through the...

https://www.dropbox.com/s/9nj4qgrd71wd5ex/Copy%20of%20Ullage%20Report.xlsx?dl=0 We have designed a simple spreadsheet with some Vlookup formulas to look at calibration tables of a tank volume within the workbook but on separate tabs. Basically the chief officer onboard the ship will enter a...

I want to create a graph which contains the following fields: - Program Name - Volume of Program Members - Sales Volume Data Point for each program The bars are across the X axis and need to be in order from lowest number of program members. It needs display volume on each bar. The y axis...

Hello, I have a below table: <tbody> Month x MONTH x+1 Volume month x Volume month x+1 PRODUCT 1 7 8 100 50 </tbody> I would like to convert it to the following: <tbody> Month Volume PRODUCT 1 7 100 PRODUCT 1 8 50 </tbody> Is there any easy way to do this? Thanks a lot

The Code Below Saves the File as "2019 Rate Volume - 2018-08-21.xlsx" I would like to have it saved like this "2019 Rate Volume - 2019-08-21.xlsx" How is the best way for me to go about this? Thank you in advance. 'Date Save Update Definitions MonthPath = Format(Month(Date), "00") & "...

Columns are Jan, Feb, Mar, Qtr1, Apr, May, Jun, Qtr2, etc. row 13 is a spread number row 25 is a volume number I'm calculating a YTD weighted average using volume as the weighting. I want the formula to return the year to date number based on the input in a certain cell. For example, if a...

Hello, I'm sure it's relatively simple but I'm trying to do a formula whereby I can return the Ref no. in column C if there is cost in column A but no volume in Column B or vice versa. I want to try and do it all in one formula but when i try and add in the OR part of the statement, excel wants...

Hi, I have a graph that one axis is volume (bar graph) and the other is premiums (line graph). I want to apply a shading to the bars (volume) to represent a mix of volumes coming from two different locations which will be held within excel. Any ideas?

i am working with two sets of information. each set has 13 values for 1 person. and this is for 13 week period. Person 1 Person 1 Dollars Volume 10 1 20 2 30 3 40 4 50 5 60 6 70 7 80 8 90 9 100 10 110 11 120 12 130 13 I am trying to get this into a graph that shows something like this...

I have the following table <colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;"> <col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt...

Hi, I have a power pivot with two fields in the value section that is further sub divided by an additional field in the column section. Basically we have item transactions (volume and revenue), with multiple types (sales, dump, and destroyed). I want to filter so that items that don't have a...

Hello Add New member here and trying to work with excel. I am sorry if I make mistake the way, I am really new to this. What I am trying to do is: Inter link two order books ( as in an exchange) of two currency pairs; using price and volume. I have tried several times to work out a formula...

Hi, I'm currently using an OFFSET function embedded in a SUMPRODUCT formula to calculate a multiple instances of a single production stream. The formula directly underneath "Total Volume" is the following...

Hi all, I have been playing around with some formulas but can't seem to find the correct one (Probably having a blonde moment) We have the following: Volume: 2.27 Actual weight: 300kg Volumetric Weight (Volume x 167): 379.09 Chargeable weight (The higher number between actual weight and...

Hi, I'm trying to create a combo graph. I have a list of terms (baseball bat, baseball, glove, baseball jersey etc) and I want to be able to compare their monthly sales to the month search volume. How would be the best way to organize the data so that I could create a combo graph that would...

I am working on a sheet where we have a list of 1100 item codes in row A. In Row B we would note the volume needed of item code in row a. On the second sheet I need the sheet to only display the item codes that have a volume and then the volume listed in the column to the right for each code...