rossmolden
New Member
- Joined
- Feb 10, 2010
- Messages
- 3
Hi All
I need to find a formula which looks up value "4" in column C and displays the whole row, then for the next row down it does the same for the next time "4" is displayed in that column.
Original Data:
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Formulated Data:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I need to find a formula which looks up value "4" in column C and displays the whole row, then for the next row down it does the same for the next time "4" is displayed in that column.
Original Data:
A | B | C | D |
row 2 data | row 2 data | 2 | row 2 data |
row 3 data | row 3 data | 4 | row 3 data |
row 4 data | row 4 data | 6 | row 4 data |
row 5 data | row 5 data | 4 | row 5 data |
row 6 data | row 6 data | 3 | row 6 data |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Formulated Data:
A | B | C | D |
row 3 data | row 3 data | 4 | row 3 data |
row 5 data | row 5 data | 4 | row 5 data |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>