Please help

[klevins]

HI,

I need to be able to select cells that are exactly 10 rows appart. For example in row a1,a10,a20,a30 there is info. The info in the cells is all text by the way.

In b1 i want to say =a1. b2 =a1+9 (which i want to show a10)

Cheers if you can help

 

[njimack]

B1: =A1
B2: =INDIRECT("A"&COUNT($B$1:B1)*10) (copy down as far as necessary)

 

[klevins]

Thanks a million