Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
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...



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.