Hi Everyone,
I have a large amount of data imported into a spreadsheet. The eventual goal is to check if the number in the value column is between The Tol_HIGH and Tol_Low. I am trying to organize the data into a columns as shown below and then maybe use conditional formatting to find the values outside of the range. Every eighth column that starts with a time is a new data set and should be a new row.
I am using this offset function to transpose the values into columns.
=OFFSET(A$2,0,ROW()*(ROW()-1)+ROW()-2)
After the second iteration the values do not line up. The value in column 1 of the third data set seems skip the cell after cell with the value 30 in it. Can someone please explain why this is happening? Is there a more efficient way to compare the data or is what I'm doing ok (I can do the basics in excel and learning the more powerful function right now)?
thanks in advance
I have a large amount of data imported into a spreadsheet. The eventual goal is to check if the number in the value column is between The Tol_HIGH and Tol_Low. I am trying to organize the data into a columns as shown below and then maybe use conditional formatting to find the values outside of the range. Every eighth column that starts with a time is a new data set and should be a new row.
Timestamp | Block | Step | Mnemonic | Value | Tol_Low | Tol_High | |||||||||||||||||||||
23:03.5 | 50 | 1 | red | 25 | 55 | 60 | 23:03.5 | 50 | 1 | yellow | 65 | 37 | 40 | 23:03.5 | 50 | 1 | blue | 18 | 5 | 30 | 00:00.0 | 50 | 1 | orange | 64 | 53 | 73 |
I am using this offset function to transpose the values into columns.
=OFFSET(A$2,0,ROW()*(ROW()-1)+ROW()-2)
After the second iteration the values do not line up. The value in column 1 of the third data set seems skip the cell after cell with the value 30 in it. Can someone please explain why this is happening? Is there a more efficient way to compare the data or is what I'm doing ok (I can do the basics in excel and learning the more powerful function right now)?
23:03.5 | 50 | 1 | yellow | 65 | 37 | 40 |
23:03.5 | 50 | 1 | blue | 18 | 5 | 30 |
1 | orange | 64 | 53 | 73 | 23:03 | 50 |
thanks in advance