Hi there,
I have got the following problem - it would be great if somebody could help me with this:
I need to find the maximum values of different parts of a large excel column. Currently, the excel data is divided in columns with (simplified) the following headings:
Now, I know the starttime and endtime of a certain interval (eg. INTERVAL 1: 09:00 - 10:00, so 60 minutes, INTERVAL 2: 10:00 - 10:20, so 20 minutes, etc.), and I want to find the corresponding maximum value IN that shift (so in this case, the maximum temperature from 9:00 until 10:00, from 10:00 until 10:15, etc).
Explained in another way; I want to create a command ("give the maximum value", or "give the average" or whatever) which searches in a column that starts at a certain value (I got those values in another column) and searches until a certain value (idem).
Would be great if somebody can help me here.
Fidodido
I have got the following problem - it would be great if somebody could help me with this:
I need to find the maximum values of different parts of a large excel column. Currently, the excel data is divided in columns with (simplified) the following headings:
Time (min) | Value (eg. Temperature) |
Now, I know the starttime and endtime of a certain interval (eg. INTERVAL 1: 09:00 - 10:00, so 60 minutes, INTERVAL 2: 10:00 - 10:20, so 20 minutes, etc.), and I want to find the corresponding maximum value IN that shift (so in this case, the maximum temperature from 9:00 until 10:00, from 10:00 until 10:15, etc).
Explained in another way; I want to create a command ("give the maximum value", or "give the average" or whatever) which searches in a column that starts at a certain value (I got those values in another column) and searches until a certain value (idem).
Would be great if somebody can help me here.
Fidodido