Home |
Search |
Today's Posts |
#1
|
|||
|
|||
progressive select
Looking for help on a function to create of a single column of data by
selecting every 4th cell in a fixed row starting with the second column in the fixed row. Example: start with: a1 b1 c1 d1 e1 f1 g1 h1 i1 j1 mike thom dick vinn joey glen rick dain ryan bill... end with: thom glen bill .. .. .. Thanks in advance. Mike |
#2
|
|||
|
|||
Hi!
Try this: =OFFSET(B$1,,(ROW(1:1)-1)*4) Copy down as needed. Biff "Mike" wrote in message ... Looking for help on a function to create of a single column of data by selecting every 4th cell in a fixed row starting with the second column in the fixed row. Example: start with: a1 b1 c1 d1 e1 f1 g1 h1 i1 j1 mike thom dick vinn joey glen rick dain ryan bill... end with: thom glen bill . . . Thanks in advance. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to select the first blank cell in column A | Excel Worksheet Functions | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Need help on Select Case | Excel Worksheet Functions |