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.

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

 

[MickG]

Try B1=IF(A1<>"",ROW(),"")

B2=IF(A2<>"",ROW(),B1)

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

and drag down.

 

[ShelleyBelly]

Cheers MickG,

Just the trick and nice and simple.

Thanks,

Tom

 

[MickG]

You're welcome