Question: How do I create a new list from an old list sorting out every second row?

how-to-filter-out-every-second-row-using-excel-formula

Answer:

how-to-filter-out-every-second-row-using-excel-formula1

Formula in F1:F10:

=INDEX($A$1:$D$20, ROW()*2-1, 1) + CTRL + SHIFT + ENTER

Formula in G1:G10:

=INDEX($A$1:$D$20, ROW()*2-1, 2) + CTRL + SHIFT + ENTER

Formula in H1:H10:

=INDEX($A$1:$D$20, ROW()*2-1, 3) + CTRL + SHIFT + ENTER

Formula in I1:I10:

=INDEX($A$1:$D$20, ROW()*2-1, 4) + CTRL + SHIFT + ENTER

Download excel example file.
how-to-filter-out-every-second-row-using-excel-formula.xls
(Excel 97-2003 Workbook *.xls)

Functions used in this blog post:

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

ROW(reference) returns the rownumber of a reference