freight

Pls help I want to find the Weighted average of the following data in a single column : I have tried Sumproduct(--(Heads="Freight")*(Value),(Heads="Sale")*(Value))/Sum(Sale) COUNTY Heads Value A Sale 200 A Freight 35 A Distance 50 B...

I'm looking for help in creating a macro that can extract select column information and create new rows data but still keep the identifying information. Not all columns will have information and I only want to extract those that have data. Below is an example of the survey data...

I’ve got an excel file containing freight detail and I’d like to construct the following formula: <colgroup><col width="64" span="10" style="width: 48pt;"></colgroup><tbody> IF order # is between 100-199 and receiving location is one of the ten locations then - freight in IF...

Hello, I’m trying to copy cells above value 0.00 in column R and S and transpose them on to column O in the same row. Following is the snapshot of the sheet I am working with, cells in Red need to be copied and transposed on to column O. This needs to be repeated until the last populated line...

Hello, I have a pivot table and an array. The pivot table has an Invoice Num (eg. 22885) and a product cost. The pivot table data is pulled from an external source (SQLDB). The array contains an Invoice Num (eg. 22885) and any freight charges that are incurred against that number. Sometimes...

I have a Freight workbook with parts listed when they came in and what is due to arrive. Column N is "Delivered date" and Column P is Carrier info. I have a Balance Due Report workbook and want to do a vlookup (in Cel ")AR33"so it will auto populate using the Freight worksheet Column P (carrier...

Hi, I am after a lookup formula to bring across the freight cost to give me a total cost of deliverys? Please see below table. <colgroup><col width="64" style="width...

I am trying to edit a macro I have to open a list of PDFs. I have been reading and trying to teach myself how to code for almost a year... but I just am slow.. the current code moves any file from folder A containing x variant to the correct folder. I would like to change the code to open all...

Good morning, this may have been asked but I will proceed anyway. I have a spreadsheet that we use to calculate costs of material that include the following. Material cost + handling + freight = total cost. Material cost is variable depending on vendor and manually inputted. Handling is static...

Hi I am using Excel 2013 and looking at setting up a pivot table and chart to show: Freight Cost Freight Budget Variance % I can't seem to get the variance column to show the percentage change between actual and budget correctly Can anyone help me with a formula? Thanks

Hello, I would like to build a calculator for how many skids (of different sizes) would fit on a 38' Long x 8'Wide Flatbed truck, a 12' Long x 8' Wide Flatbed Truck and a 48' Long x 8' wide truck. Is there any way to input multiple skid sizes and configure which truck those skids would be best...

I am hoping to get some direction on this issue. In a nut shell… I am discouraged on what route to go- Access or some other DBM. What I am doing is creating an in-house database for a Freight broker company that I work for. There are only 5 of us here. The company as been in business for over...