measurement

hello everyone. im trying to get excel to look up a value from a list of possibilities. to give you some context im trying to create a spreadsheet to show me the possible universal joint bearings from a given measurement, either A or AD, with A being the measurement across the bearing, and AD...

In my work I take around 100 different measurements. Each measurement has it's own spec for high and low tolerance. For example measurement #1 can be between 0 and 1. Measurement #4 could be between 0 and 1.5 and so on. I use conditional formatting to highlight the measurements that are...

Here's what I have: Column A is populated with numbers. Column be has a unit of measurement (sp, cp, gp or pp) I want E20 to keep a running total of all of the numbers that are "sp" E21 to total all the cp, E22 to total the gp etc... Column B's units of measurement will change. So for example...

Hi all, Looking for some help on this problem. I have 5 different columns with different measurements (these can be anything) and want to create a list of all the different unique combinations and then count how many of each unique combination there is. There can be thousands of different...

Hi. I have a spreadsheet which I'm wanting people to submit figures for measurements they take and for them to know which dates they are due to provide a measurement. Different people will be measuring at different frequencies - some weekly, some fortnightly and some monthly. I've already...

So I have a column with information like this: XC-163 0827m Timber problems 0600m failed picture cv-76 ligts out 0987m p3 etc What I need is to create a column only with the measurement info in it which goes behind the m, in this case: 0827 0600 0987 Any ideas of which functions I can use...

<tbody> Number Description Measurement (mm) 5897652 Erhöhungsrahmen, MEF33, 320x320x75 2145456 text.... Größe: BxHxT = 900x1250+(800(Sockel) = ignore)x340 mm Text... 2548578 Only text (ignore) 3579513 Text… H:1710mm, B:838,5mm, T:277mm </tbody> Hello everyone, I'm struggling with...

Hi All, First post so please take it easy with me. I don't seem to be able to attach anything to show you the matrix i have but will try and explain the best i can. I am looking to create a generating price list based on window size for curtain and blinds. If i create a workbook and sheet...

Hi, I need to calculate the averages from a column of triplicate data, and am struggling to find and correctly use a formula to do this. Here's what the data looks like: Column A Column B Column C ID number Trial number Measurement 1 1...

I hope its ok to post questions about google sheets... I have the following problem: I need the following formula to convert into FEET" & INCHES" only. For example, my formula right has 13.8750(13' 7/8") converting to 166.5 INCHES. This conversion is correct but now what I need it for. I need...

Hi, Workbook Master has 3 worksheet. Two worksheet as mentioned below and final worksheet need to create from other 2 by transpose and Vlookup. Worksheet1: ReportConfig <tbody> Site Id Report Config A3offset Hysteris 64001_1 1 2 1 64001_1 3 3 1 64001_1 23 4 1 64001_12 1 8 2...

Hi Guys, I have a weight on 2 different sheets. One sheet reports it in KG the other reports it in LBS With my limited knowledge of VBA I have tried writing the following code: 'returns weight measurement with 2 decimals - WORKS sheet2.Range("Z2").Formula = _ "=VLOOKUP(U2,'DG by Flt...

Okay. Here's a stumper (for me at least it is). I need to convert the following into radians: 65 feet/1 second * 12 inches/1 foot * 1 Radian/8 inches I know the answer which should be 97.5 radians. It's just getting the right formula in Excel.