ShelleyBelly
New Member
- Joined
- Mar 2, 2011
- Messages
- 44
Hi There,
I'm sure I must be over thinking what is a simple problem but the solution I came up with originally is a bit of a work around! Basically I need a formula for calling up the row in which the previous value in column A resides. The solutions should look like the those in column B below.
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
Many Thanks in Advance
Tom
I'm sure I must be over thinking what is a simple problem but the solution I came up with originally is a bit of a work around! Basically I need a formula for calling up the row in which the previous value in column A resides. The solutions should look like the those in column B below.
A | B |
1 | 1 |
1 | |
1 | |
32 | 4 |
4 | |
4 | |
4 | 7 |
7 | |
7 | |
5 | 10 |
10 | |
10 | |
10 | |
10 | |
45 | 15 |
15 | |
2 | 17 |
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
Many Thanks in Advance
Tom