| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formula to make selection
hi, i need to drag a formula down a column which selects every tenth cell
from another column, please. for example in column d3:d102 i need to have every 10th entry in column a3:a1002. thanks for your time. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dragging formula to make selection
On Jul 30, 9:52 pm, memobile wrote:
hi, i need to drag a formula down a column which selects every tenth cell from another column, please. for example in column d3:d102 i need to have every 10th entry in column a3:a1002. thanks for your time. Maybe... =OFFSET($A$3,(ROWS($1:1)-1)*10+9,0,1,1) Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dragging formula to make selection
The following formula in D3, drag down as needed:
=INDEX($A$3:$A$1002,(ROW()-3)*10+1,1) -- John C "memobile" wrote: hi, i need to drag a formula down a column which selects every tenth cell from another column, please. for example in column d3:d102 i need to have every 10th entry in column a3:a1002. thanks for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging Down a Formula | Excel Worksheet Functions | |||
| How to make View Fit Selection work? | Excel Discussion (Misc queries) | |||
| Excel range selection as if dragging, keyboard not responding | New Users to Excel | |||
| how to make a menu selection in the same cell? | Excel Discussion (Misc queries) | |||
| dragging a formula | Excel Discussion (Misc queries) | |||
Linear Mode
