Excel Forum

Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function

See how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns. INDEX function with a Number Incrementing formula element (uses INT & COLUMNS functions) that generates the numbers 1,1,2,2,3,3.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.