Search results for query: *

some *kind

Yea, I tried a delay. I think I need to reference some time of form function, but not sure how to do that. If you go to that link and select an object in the first drop down, you see the subsequent dropdowns change. I have to trigger THAT somehow...

Does my question make sense? I'm happy to clarify. TIA!

I created a script to BEGIN to do what I need. This script interacts with the initial form. I can fill out the form and submit, but it errors. Upon further inspection, after a selection is made in the first dropdown field, the form is supposed to refresh with updated dropdown options. With my...

Getting same results as my attempt. 3month oil_vol and standard oil_vol match values.

Thanks for the reply. I changed up the WHERE ?, but not understanding which date reference I should change or what to change it to. Not totally sure I applied your last suggestion correctly either. Now Oil volume and average oil volume are identical. SELECT; SELECT A.Well_Name, A.Test_Date...

Also, I really need this to SHOW the following columns Well_Name, Test_Date, Oil_Vol, Water_Vol, Gas_Vol, Water_Cut, 3Mon_Avg_Oil_Vol, 3Mon_Date, 3Mon_Avg_Water_Vol, 3Mon_Avg_Gas_Vol, 3Mon_Avg_Water_Cut,Delta_Oil_Vol, Delta_Water_Vol, Delta_Gas_Vol, Delta_Water_Cut. For the 3 month avg date...

Ok...got it to work...sort of. But I'm getting the same problem as before where the data is not unique to each well. But instead, showing the same data for each well (depending on date) SELECT A.Well_Name, A.Test_Date, A.Oil_Vol, A.Water_Vol, A.Gas_Vol, A.Water_Cut...

No luck. I've tried putting commas after each (Select statement, but it's not working. I either get a syntax error or punctuation error...

Something like.... (not working) Got error saying "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM 3Mon_Average_2...

That worked. Now trying to apply it to the rest of my criteria and getting an error about an extra ) SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol),AVG(Water_Vol), AVG(Gas_Vol),AVG(Water_Cut) FROM 3Mon_Average_2 B WHERE B.Oil_Vol = A.Oil_Vol AND...

I must have applied the technique wrong... every well has the same average for the same time period. When the date moves up a day, the average changes (but is the same) for all wells still. SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM...

Regarding well testing: Posted 5 months worth of data in the attached spreadsheet. Basically I have 6 columns of data: Well Name Test_Date Oil_Vol Water_Vol Gas_Vol Water_Cut I need to calculate a rolling 3 month average per well on oil,water,gas, and water cut. Easy to do in Excel, but not...

I think for this instance, I am in need of a specific formula for my spreadsheet. Ive been reading non stop on this since my original post, but can't seem to translate any formula to work with my spreadsheet. In this version, I've cleaned up a lot of the data improved the function in general...

Which index? =index(theFormula,1,1) or =index(theFormula,count(theFormula),1)

Any chance you can throw out an instance of what you are describing... I still can only get the first instance. I don't get how to reference more than 1 row. Like for LCP017 for example.

...a spreadsheet with 4 columns representing quarters (Q1-Q4). For each quarter there are mixed dates and text in the cells. For cells with "Pending*" and dates that fall within that quarter, I need to count the occurences. This number represents the number of failures for that well, for that...

I'm making an assumption that I can use VLOOKUP in this way. I'm assuming that FALSE means the first instance that matches the well, and TRUE means any other instance that matches the well. I wonder if there is a way to take the max of the vlookup findings? I'm sure the problem isn't your...

EDIT - you have to click SHOW CALCULATION STEPS

When I get the #VALUE result with...