On Apr 19, 6:00*pm, Domanda wrote:
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!

H1 can be 0, but not a heading. In my version 2007 it's not this
which causes the #N/A but lower down at the bottom.

=IF(ISNA(H2),"",OFFSET($A$1,H2,2,1,3)) as an array fixes things
somewhat.