Excel Forum
Similar Content
Get the Row or Column Number of a Cell in Excel
Tutorial: How to get the row or column number of the current cell or any other cell in Excel. This t...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...



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.