Relative Postion of next value in array

[ShelleyBelly]

Hi Guys,

I'm sure I must be over thinking this but I don't seem to be able to find the solution to what seems a simple problem. I've a column of values separated by blank cells and I need a formula to return the relative position in the array of the next value in the column. The results of such a formula should look like either column B or C.

[TABLE="width: 260"]
<tbody>[TR]
[TD="class: xl63, width: 65"]A[/TD]
[TD="class: xl63, width: 65"]B[/TD]
[TD="class: xl63, width: 65"]C[/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]11[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]13[/TD]
[TD]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]13[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Many Thanks in Advance,

Tom

 

[shg]

One way:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr][tr][td]

1​

[/td][td]

4​

[/td][td]

4​

[/td][td]B1: =ROW() + MATCH(TRUE, INDEX(ISNUMBER(A2:A$14), 0), 0)[/td][/tr]
[tr][td]

2​

[/td][td][/td][td]

4​

[/td][td][/td][/tr]
[tr][td]

3​

[/td][td][/td][td]

4​

[/td][td][/td][/tr]
[tr][td]

4​

[/td][td]

32​

[/td][td]

7​

[/td][td][/td][/tr]
[tr][td]

5​

[/td][td][/td][td]

7​

[/td][td][/td][/tr]
[tr][td]

6​

[/td][td][/td][td]

7​

[/td][td][/td][/tr]
[tr][td]

7​

[/td][td]

1​

[/td][td]

11​

[/td][td][/td][/tr]
[tr][td]

8​

[/td][td][/td][td]

11​

[/td][td][/td][/tr]
[tr][td]

9​

[/td][td][/td][td]

11​

[/td][td][/td][/tr]
[tr][td]

10​

[/td][td][/td][td]

11​

[/td][td][/td][/tr]
[tr][td]

11​

[/td][td]

4​

[/td][td]

13​

[/td][td][/td][/tr]
[tr][td]

12​

[/td][td][/td][td]

13​

[/td][td][/td][/tr]
[tr][td]

13​

[/td][td]

5​

[/td][td]

#VALUE!​

[/td][td][/td][/tr]
[/table]

 

[ShelleyBelly]

Hi Shg,

Perfect, thank you very much, just the trick.

Tom