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




Be the first to comment

Leave a Reply