On Mon, 18 Apr 2011 21:16:05 -0700 (PDT), Xt
wrote:

e records over to cols I, J, .. using
VLOOKUP or OFFSET.

H1 is empty. In H2 put =H1+MATCH("a",OFFSET($A$1,H1+1,1,9999,1),0)
Copy down. The record numbers should appear.

Pity about the #N/A's when you run out of records. Someone might
think of some ingenious way round this.

xt



thanks a lot

why "=H1" if you wrote H1 is empty?

and #N/A is indeed what I wanted to avoid..

thanks a lot anyhow!