rod

hi all new to the board, I am trying to extract information from one cell into three different cells. My main issue is that not all of the descriptions in the cells are anything alike, see below for an example of seven different part descriptions Description 1 <colgroup><col></colgroup><tbody>...

All 4 cells are using the TRIM function from other workbooks. I need H Rod QTY to subtract the Open QTY from the Total QTY each time the specific Rod Manufactured comes up on the schedule. The 2nd part is, after getting the above, how could this function calculate by the earliest date first...

I have a list of comma delimited text that I would like to VLOOKUP the values of, preferably without using Text-to-Columns. I would like to use VLOOKUP so that if there is an error I can return "Error". Sheet 1 is my lookup list. <tbody> NUMBER NAME <tbody> C-1032-4 </tbody> <tbody>...

It would be so much easier to have this in a spreadsheet. What I'm looking for is a formula that would tell me when I'm at "Top of Descent" i.e. or how far out from the airport, for example, I have to be to start my descent. Also, I'd like to know my rate of descent, (ROD) And if it's not...

Hi all, newbie here, don't know what else to use besides IF function for this. Reaching nesting limit doing it this way. Any alternative ideas are appreciated! Formula in B5 of image attached: =IF((AND(C2=1.5,D2="L",H2=0.625)),'[1-MASTER.xls]A & LH SINGLE ROD END'!$M$10, (isolating this on...

I'm trying to make a spreadsheet that figures out automatically where the rod break is based on weight(oil well rod string) For example a new full rod string weighs: 18,425 Current rod weight: 15,965 Obviously have a rod break and I am trying to make a sheet to calculate where the break is. I...