=INDEX($B$1:$B$100,(ROW()-ROW($A$1))*8+1)

JBSAND1001 wrote:
Hello,
I am looking for a formula that will copy data either text or
numerical data in a sequence but for every 8th cell. I keep running into the
problem of excel using the abosulte/relative reference to capture the string.
For example

Cell A1:A20 = 1-20 I want to capture in sequence 1-20 in column B except
every 8th cell.

A1=1 B1=1
A2=2 B2=""
A3=3.... B3="".....
A20=20 B8=2
B9=""
B10=""....
B16=3