Quote:
Originally Posted by kraway
I have a column of data, say column A. I want to show the value of every 5th
row in column A in column C. This means cell C1 will reference cell A1, cell
C2 will reference cell A6, cell C3 will reference cell A11, etc. Is there a
formula that I can drag down column C to produce this result?
|
Kraway:
Paste this formula in cell B1 and copy down as far as needed.
Code:
=IF(MOD(ROW()-1,5)=0,ROW(),"")
Paste this formula in cell C1 and copy down, hide column B.
Code:
=IF(ISERR(SMALL(B:B,ROW(A1))),"",OFFSET($A$1,SMALL(B:B,ROW(A1))-1,0))