Excel Magic Trick 1142

Get Every Other Row with Formula: INDEX and ROWS*2

DESCRIPTION

See how to create a formula to Get Every Other Row with Formula using INDEX function and ROWS function. See how to increment the numbers 2, 4, 6, 8… or create sequential numbers like 2, 4, 6…

WORKBOOKS