You're welcome. Thanks for the feedback!

Biff

"Ray Elias" wrote in message
...
Dude, you ROCK!!!

I thought it would have to use OFFSET, but the couple things I tried
weren't
working.

Thanks for the quick reply!!!

"T. Valko" wrote:

Try this:

=OFFSET(A$1,(ROWS($1:1)-1)*5,)

Copy down as needed.

Biff

"Ray Elias" wrote in message
...
I hope I can explain this clearly.

Assume in COLUMN-A I have data from ROW-1 through ROW-500

In COLUMN-B, I want B1 to refer to A1; B2 to refer to A6, B3 to refer
to
A11
(every 5th one).

Is there an easy way to create COLUMN-B without me having to enter in
100
cells manually?

My initial thought was to create the first 3 or 4 and then select and
drag
down, but that doesn't seem to work.

Thanks in advance!