| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help One Way did not work
The reply to my problem below did bring the variable over to column b,
however, the fill option repeats the same variable in row 1 and does not extract the data in every 3rd row. What do you mean by copy down? nine thousand records! One way: B1: =INDEX(A:A,(ROW()-1)*3+1) Copy down. In article , Arlene wrote: need step by step instructions to extract data from column A starting with A1 and grab A4, A7, A10, A13, etc. -- ALFR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Erase & Draw Border functions no longer work | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
| Service work order | Charts and Charting in Excel | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Threaded Mode
