Hi there,
I have copied samples in the form of two data tables and in essence, I would like Table 2, columns F to H, to return data from Table 1, only when the value in column C is greater than zero. Typically, Table 1 will run to thousands of rows and so it would be good to only summarise relevant data.
Any help would be much appreciated.
Ben
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;">
<col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" span="2">
<col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;">
<col width="64" style="width: 48pt;">
<col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;">
<col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
I have copied samples in the form of two data tables and in essence, I would like Table 2, columns F to H, to return data from Table 1, only when the value in column C is greater than zero. Typically, Table 1 will run to thousands of rows and so it would be good to only summarise relevant data.
Any help would be much appreciated.
Ben
A | B | C | D | E | F | G | H | |
1 | Project | Item | Year 1 | 1 | Project | Item | Year | |
2 | A | 1.1 | £500 | 2 | A | 1.1 | £500 | |
3 | B | 1.1 | £0 | 3 | C | 1.2 | £200 | |
4 | C | 1.2 | £200 | 4 | B | 1.3 | £400 | |
5 | B | 1.3 | £400 | 5 | C | 1.1 | £100 | |
6 | B | 1.1 | £0 | 6 | A | 1.4 | £700 | |
7 | C | 1.1 | £100 | 7 | ||||
8 | A | 1.4 | £700 | |||||
9 | A | 1.2 | £0 | |||||
TABLE 1 | TABLE 2 |