Hi
I need to extract data from a series of columns to build a new array. Please look at the table below:
<tbody>
</tbody>
Column A & D have an ascending error number. I need to find the non-zero rows from Column A & D and then pick up the data that is in the next two columns. The objective is to create a new array that looks like this:
<tbody>
</tbody>
My first thought was to capture the Address of the row and column that holds the error number, and then use Offsets to extract the information from the other two rows. I hoped that I could use the Match function in an Array formula and present columns A & D as one continuous array but I could not figure out a syntax that Match would accept.
Does anyone have any suggestions?
Thank you
Brian
I need to extract data from a series of columns to build a new array. Please look at the table below:
A | B | C | D | E | F |
Error Num | Row Key | Message | Error Num | Row Key | Message |
0 | 0 | 99 | 0 | 0 | 99 |
0 | 0 | 99 | 0 | 0 | 99 |
1 | 2.07.1 | 13 | 0 | 0 | 99 |
0 | 0 | 99 | 0 | 0 | 99 |
0 | 0 | 99 | 4 | 2.09.4 | 16 |
0 | 0 | 99 | 0 | 0 | 99 |
0 | 0 | 99 | 0 | 0 | 99 |
2 | 2.12.2 | 13 | 0 | 0 | 99 |
0 | 0 | 99 | 0 | 0 | 99 |
3 | 2.14.3 | 13 | 0 | 0 | 99 |
<tbody>
</tbody>
Column A & D have an ascending error number. I need to find the non-zero rows from Column A & D and then pick up the data that is in the next two columns. The objective is to create a new array that looks like this:
1 | 2.07.1 | 13 |
2 | 2.12.2 | 13 |
3 | 2.14.3 | 13 |
4 | 2.09.4 | 16 |
<tbody>
</tbody>
My first thought was to capture the Address of the row and column that holds the error number, and then use Offsets to extract the information from the other two rows. I hoped that I could use the Match function in an Array formula and present columns A & D as one continuous array but I could not figure out a syntax that Match would accept.
Does anyone have any suggestions?
Thank you
Brian