Relative Postion of previous value in array

[ShelleyBelly]

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.

[TABLE="width: 130"]
<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 65"]A[/TD]
[TD="class: xl66, width: 65"]B[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]1[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]1[/TD]
[/TR]
[TR]
[TD="class: xl64"]32[/TD]
[TD="class: xl64"]4[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]4[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]4[/TD]
[/TR]
[TR]
[TD="class: xl64"]4[/TD]
[TD="class: xl64"]7[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]7[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]7[/TD]
[/TR]
[TR]
[TD="class: xl64"]5[/TD]
[TD="class: xl64"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"]45[/TD]
[TD="class: xl64"]15[/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]15[/TD]
[/TR]
[TR]
[TD="class: xl64"]2[/TD]
[TD="class: xl64"]17[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


Many Thanks in Advance

Tom

 

[MickG]

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Try
B1=IF(A1<>"",ROW(),"")[/TD]
[/TR]
[TR]
[TD]B2=IF(A2<>"",ROW(),B1)[/TD]
[/TR]
</tbody>[/TABLE]
and drag down.

 

[ShelleyBelly]

Cheers MickG,

Just the trick and nice and simple.

Thanks,

Tom

 

[MickG]

You're welcome