length

I am looking to calculate the overall pipe length required for manufacturing... For example, the known data is a Pipe (50mm diameter), a bend with a Radius of 600mm and an ANGLE of 45 degrees. The Data is laid out as; Pipe Size 50, Degree 45, Radius 600, Cut Length ??? The sample...

Greetings, I would like to be able to copy a string value from one cell to another. The string value to copy will be located in the target cell after an "&" and go until the last character in the cell. The length of the string value will vary from cell to cell. Any ideas as to how something...

PROBLEM I need to extract the Length and the Width (to do some calculations) of each product that comes through my system. ANALYSIS The data is held in one Excel cell and looks like this :- (various lengths of data) – L1111m, W222mm, T33um – (other various lengths data) or (various lengths of...

Hello, Please consider helping me with my problem. I have different length rows I would like to analyze with the trend function but I don't know how. For example: <tbody> A B C D E F G H 1 Trend 1 Trend 2 1 2 3 4 5 6 2 4 3.5 4 8 3 3 8 11 2 5 4 6 6 6 5 4.5 4.8 1 7 4 3...

Hi All, I have a set of lines similar to the one below, and I am only trying to get the text between "of" and "Jan" or any other month. The text length is different. What is an appropriate formula to get this? All help is greatly appreciated. <tbody> Sum of Salaries Jan </tbody>

I am trying to copy a range of data from one sheet to another. the range of data being copied is always a different length depending on the date selected, also the copied data has to be pasted to the bottom of the master copy list thereby creating a full list for the user to search for specific...

Hi Guys, Need help with the below. So I need to copy the whole row of those crops that have changes in length from day 1 to day 2. The below is just an example, true data contains many rows and columns. I don't want to add another column that will check if day 1 and day 2 are the same. What...

This works perfectly for populating a cell with everything left of the first _. =IFERROR(LEFT(B11,FIND("_",B11)-1),"") I was wondering, is there a way to make it show everything after the last "_"? I've been messing with it but I just can't get it to work. The file names are never the same...

Hia, I have the following formula, which works when entered into a cell directly, but when I attempt to include it in a macro the text turns red & is not accepted. Unfortunately there is no error message displayed so I don't even have a starter to hit google with, so I'm assuming that at 1021...

Hi guys I am after a formula be it vlookup or Match, that can give a result based on a particular word is lying in an adjacent cell. Any help would help save a lot of data input! Eg.... Key <tbody> Angular ANGL Radius RADI Length LENG </tbody> Data (Column 1) + Desired Result...

I'm using some data that came from an IVR system. Many of the numbers I am using are time intervals formatted as HH:MM:SS like speed of answer, length of call, etc. I need to sum these numbers and also get them to sum in a pivot table, but they will not. I have tried every format that...

Hello, I need help with macro to copy rows to new sheet based on length. if cell in column J has 9 or 14 characters than copy entire row to new sheet. I have something like this for another column and that is working but now I need length for another...

In this sheet, column H finds the weekly MAX from 01/02/1993 based on the OFFSET values given in columns F and G. The formula in column H is =MAX(OFFSET($B$3,F2,0,1,1):OFFSET($B$3,G2,0,1,1)) The value in H2 is the MAX from 01/02/1993 to 05/02/1993 (calculated from data not shown below) The...

Hello - I have a file where users enter in codes (col j) and they must only be a length of 10. I am using a formula (in col I) to check if they are length of 10, otherwise it will color the cell red and put in word "invalid." I want to prevent users from saving the file until they fix any codes...

Hello, I have a worksheet that I am having users paste data in to. When they do certain cells can have data that is very wide. I don't want to use Wrap Text because the amount of data is large and I need to retain the cell width and height as I have them set. I would like to use VBA to check...

Hi, excel masters. I don't know much about macros and VBA but I know that this can be done. if someone would be nice to help me, i would be tremendously grateful. Thank you here's what I want to achieve, 1. I want to eliminate all texts that have "KM", "Litres", "Liters" 2. I want to...

Hi All, Have to do huge task of reporting more than 80 lakhs rows of data at account level to regulators. Request your help for construction of code in access which can check the length of the data fields and also convert them into text post checking as per the bytes mentioned. <tbody>...

Hi, I have a set of data that was extracted from an old 90's database into text which I have imported to Excel. My one issue is a single string of text containing 8 digit sequence numbers, but with no space or other delimiter. These cells (1000's) vary in length from 7 sequences on the...

Hi, I have 2 elements that I would like to use to find the final result. I have quantity and length, upon which I am looking for price per unit. Here is a table of the information with quantity along the X axis and length down the Y: <tbody> 2500 5000 10,000 15,000 78m 0.76 0.73 0.71 0.70...

I’m trying to come up two formulas that can extract characters from the middle of a string of text of varying lengths. Here is an example- A1: 1234 309 Embankment Cu. Yds. 217 B1: 4567 587 12" Conduit, Type B, As Per Plan Lin. Ft. 14 C1: 4321 5432 Pull Box Adjusted to Grade - Contingency Ea. 1...