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
