unit

Hi All, I have the following raw data: <tbody> A B C F G Material Bill Date Unit Price 14/05/2018 A 03/05/2018 323 A 10/05/2018 300 Material Unit Price A 28/05/2018 300 A 323 A 02/06/2018 278 C 1050 A 16/06/2018 210 R 500 C...

Need help with a formula that would be a dynamic SUMIF of sorts. I have a dataset of GL codes (XX-XXXX-XXXXX) for which I need to sum amounts based on the values in two columns. The left two segments (7 characters) represent the Business Unit and each Business Unit can have multiple GL Codes...

Hi, I need the y-axis on my chart to autoscale, so that the major units will be 5, 10, whatever, as appropriate, when the values are large. But sometimes the values will be very small and the autoscale sets the major unit to 0.5. I am counting people who meet certain criteria, so this is not...

Hi - This is my first time posting so bear with me. I work for a manufacturing company and we micronize raw materials into fine particle sizes and pack them into different size packages. The workers manually track the start and end times for each unit (bag/box) produced on their shift on a piece...

I have a worksheet as ff: column A Column B Column C materials unit of measure quantity sorted on column A then SUBTOTALed on column C but after that -- only Column A & Column C were shown the column B is blank! is there a way to...

Hi everyone I have a table in A1:D9 in which a unit is plotted for each person against various locations. Cell G1 is a data validation/drop down in which you can select a person from the table (in the example below I have taken Person 2). The formula therefore needs to reference cell G1. I...

I have an Excel spreadsheet with house addresses that are inconsistent. I would like to write vba code that searches for the word "UNIT" in column A and then concatenates it with the address row above. Something like: <code>Sub ConcatenateRowAbove() Dim aCell as Range Dim lrow as Range Dim...

Good Morning Team, A new challenge, I have a quote template where we add enter prices into the Sheet1 unit price column. Sheet2 contains a pricing database with our total products list with costs. Can someone help me with code to look at "Part Number" & "Unit Price" from Sheet1 and find/update...

Hi everyone, Not sure if this is possible but for reasons i can not go into I need a way to change a number the was calculated in decimal into unit7 and unit 6 (so binary is unit 2 if you know what I mean :-) ) any ideas? Tony

Hi All Is it possible to maximise 2 variables using solver? Basically i have a sales organisation, i want to get the optimum product mix to maximise both Sales per unit sold & Profit per unit sold. Some products have high revenue but would loose money and vice versa. It is also subject to...

I need help on this problem. I have a large dataset, and I need to get a count for every UNIQUE 3 Bedroom record, below. So if floor plan type = 3 Bedroom, then count the records, but only for UNIQUE unit numbers and UNIQUE property name. IE, if there are 4 unit E1001 at property xxx, that...

i have a workbook with 4 sheets 1st three are Jan, Feb, Mar and 4th one is home. Columns are style no., qty and unit price. i want to check index match the unit price of mentioned style number from all three sheets. Like i want a formula in HOME sheet in cell C2 which see style no. in cell A2...

Hello, i have tried to do this but can’t seem to figure it out. i have a work book with 2 sheets and I want it to match two columns with two columns on anouthher sheet and if they are the same then to copy anouthrr column. Example bellow sheet1 A................. B. .... E...

Good Morning master excel semuannya, I am a beginner in using excel application. Please help to determine the average cost / unit (in marking with yellow) in the data sales, sales returns and purchase returns with excel formulas. If I analyze the data determine the unit average cost / unit with...

I need a way to move data from dataset 1 to dataset 2 using a formula in dataset 2 that references dataset 1 via label (quantity, price, shipping cost per unit) and item code. Does anyone have any suggestions? https://imgur.com/a/CpVRn

Hi can someone help me in the best way to do what I'm trying to achieve. I want a set of drop lists to filter based on the previous selection. So using the example data below I want to be able to select a product, then the next drop down list is to be able to select a quantity based on the...

Hi Folks, I am trying to SUM figures with miles (mi) inside the same cell. I tried to use this already to disregard the miles unit but it gives me a #VALUE error. =SUM(SUBSTITUTE(A2:A7, "mi", "") +0) Any other suggestions? Thanks.

Hei, Im just begin to work with Excel and my english is limited so sorry if this question is answered many times. I have problem how to update prices. Every year I got price list in excel format with 30 000 lines . I used search and copied data in structure I need but on separate spread sheet ...

I am using vba to search for searching for certain key words/phrases in excel spreadsheets. Sometimes a phrase may have extra spaces in between words i.e. "Forecast O&A $ per Unit" When I search i use "Forecast O&A $ per Unit" (only one space between each word). In my spreadsheet...

Hi all, Hoping you can please help, I have reviewed many of the proposed solutions to a progressive calculation I am trying to solve but am not winning (or looking hard enough). The solutions I have found as far deal mainly with percentages which is not working completely. I have a progressive...