Microsoft Excel Functions & Formulas

Use the OFFSET function to filter every

other column

This example shows a table where every other column has to be fil-

tered. Use the COLUMN function to get the actual column, and

combine it with the OFFSET function to reach the goal.

4

To extract every other column:

1. In cells A2:G6 type numbers from 1 to 6.

2. Select cells A9:D13 and type the following formula:

=OFFSET($A2,0,(COLUMN()-1)*2).

3. Press <Ctrl+Enter>.

Lookup and Reference Functions 235

9

Figure 9-19