Search results for query: *

I'll try using your solution from earlier then. If it were possible to upload the full set of data I could show you, since I can't I'll continue on my own. Thank you for the help though

I was just providing a random set of data with which you could look at the tolerance bands. I didn't check whether the set was a pass or fail. This is a set which fails those bands. And yes, I do want help, I'm just finding it difficult to explain exactly what I want. y x 0.0131 0.0000 0.0160...

What do you mean by value pair? As I said, none of the x values are the same so I can't simply compare values. I'm not sure whether the data I provided you with would pass or fail.

Here's a full set of tolerances, we only use the tolerances from x = ~0 to x = ~1 so some at the bottom are unused. Columns in pairs: Nominal, Lower, Upper, Actual. Nominal and Actual are y then x Lower and upper are x then y Nominal Lower Tolerance Upper Tolerance Actual y x x y x y y x...

Basically the upper tolerance has a greater number of data points than the lower or actual measured data. By that I mean that if I am analysing 100 data series I'd like to know how many go outside of the upper tolerance and how many outside of the lower tolerance. So if you drew two curves on a...

Is it possible for excel to calculate the number of series which at some point go out of tolerance? e.g. If a series 1 is the lower tolerance and series 2 is the upper tolerance can I check to see whether series 3 lies within this range or not? The number of values used for the upper...

Thanks for the help. ScreenUpdating has always been off. I'm trying it out with your code now.

There are ~30 different colours the code goes through to test for. I don't actually use Type in the code... I cut down all of the detail just to show the loop as the rest is just a repetition of the two if statements and a lot of calculations which cannot be changed. If you want to see the...

I've missed out all of the detal in the code except for the way the loop works, any idea on how to make this faster? (I never know where the coloured cells will begin or end) Thanks for your help ____________________________________________________________ For R = 1 To LastRow(0)...

I have a loop which looks down thousands of lines and across 20 cells on each row. The code takes a huge amount of time to run, since it is looped on a lot of files. Is there a way to make the code only look at a line if the line contains colour since many are blank? Thank you

I'll upload the files at some point later today if possible. Is it possible to edit posts btw?

Okay, thanks for the help. I'm not able to upload anything. Uploading files is blocked here. However, I'll list what I can. If anything doesn't make sense I'll attempt to explain what is needed. The column headings I need are: Measured_Date Measured_Time Serial_No Feature Nominal Actual...

Sorry, forgot to mention we runs on Windows 2000.

I'm completely new to SQL and would like to know exactly what I can do with it. I want to be able to extract a load of data for a feature, calculate some new values, order the data by date and take the most recent 30 values. Then repeat this for each feature. An example of the value I'd want...

Immediately before the line of code to print. The formats are all correctly displayed on the screen, if I print manually they are also correct. However, if the code prints automatically they are all reset.

Using a macro I have imported some data and created 8 graphs on a sheet which is then printed. The printout reverts all character formatting to the default sizes. How can I prevent it from doing this so the formatting I specify in the code is retained? I've done this before in other macros...

Sorry, nevermind, it seems to be working now that I've re-run it. I don't know why since I didn't change anything.

Thanks. This works fine for the data copying bit, but doesn't work when I'm trying to select a range for a graph. Any ideas?

I have been trying to create some code behind a command button in a worksheet. When it is clicked it links to another sheet and collects data which it then uses to create a graph. I always get an error: ___________________________________________ Runtime Error '1004': Application-Defined or...

Okay... And if I were to use your method instead what formulae would I used in place of SpreadsheetFunction for each? Thanks