If I have a spreadsheet which is never the same size, and I need to select a cell from a given column which is never the same value. What would the macro command be?
I am guessing it would be something like a MIN command within a selected range to find a value less than zero?
Thanks.
PS. In case you need more information, the project I am trying to complete is a macro that will take data that is captured from a a test I am running and through a macro give me the data I require. I am just starting so any help is greatly appreciated.
The data consist of 7 columns labeled as TIME_SEC, VOLTAGE, CURRENT, IN_PRESS, OUT_PRESS, IN_TEMP and UNIT_TEMP.
The number of rows can vary but are usually from 10000 to 16000.
Here is the information I need to extract from this data.
1. Determine the opening time. Opening time is defined as the time from when power is applied to a sharp dip in current is noted.
2. Determine the closing time. Closing time is defined as the time from removing power until the first point outlet pressure is continuously decaying at a rate equal to or greater than -2 psig/msec.
3. Determine Vent time. Vent time is defined as the time from removing power until outlet pressure decays to 150 ±5 psig.
I am guessing it would be something like a MIN command within a selected range to find a value less than zero?
Thanks.
PS. In case you need more information, the project I am trying to complete is a macro that will take data that is captured from a a test I am running and through a macro give me the data I require. I am just starting so any help is greatly appreciated.
The data consist of 7 columns labeled as TIME_SEC, VOLTAGE, CURRENT, IN_PRESS, OUT_PRESS, IN_TEMP and UNIT_TEMP.
The number of rows can vary but are usually from 10000 to 16000.
Here is the information I need to extract from this data.
1. Determine the opening time. Opening time is defined as the time from when power is applied to a sharp dip in current is noted.
2. Determine the closing time. Closing time is defined as the time from removing power until the first point outlet pressure is continuously decaying at a rate equal to or greater than -2 psig/msec.
3. Determine Vent time. Vent time is defined as the time from removing power until outlet pressure decays to 150 ±5 psig.