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!