Show Every 3rd Row
Assuming range starts from cell A1 downwards.
=OFFSET($A$1,ROW()*3-1,0)
Change number 3 to any number of rows you want
To include cell A1
=OFFSET($A$1,ROW()*3-3,0)
or
=INDEX(A:A,ROW()*3-2)
© Copyright
andrewsexceltips.net
All Rights Reserved.