Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
trying to select every other 1st column, of 2 columns sets.
20 columns, 10 sets. only use one at a time for formula trying to make. using fixed cell $C$2 to enter 1-10. (first col is a low number, 2nd col is hi). selecting 1 column at a time works for the following example. =INDEX(E49:X9,1,$C$2) but for example, need 2 to select column G, 3 column I .. do I need use of / get help with MOD() ? thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the HELP INDEX | Excel Discussion (Misc queries) | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
index/index | Excel Worksheet Functions | |||
Using INDEX & AND | Excel Worksheet Functions |