How to select every other COLUMN


N

Nastech

trying to select every 1st / other column. 20 columns, 10 sets. want to be
able to select any 1 of 10 columns (use fixed cell $C$2 for 1-10).
selecting 1 column at a time works for the following example.

=INDEX(E49:X9,1,$C$2)

for pairs of colums:

1 E (2nd cols: F H J L... not used)
2 G (3rd col)
3 I (5th col)
4 K (7th)
5 M (9th, etc..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top