| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a formula to copy cells in a particula way
Try adapting TM's idea like this ..
Put in the start cell, eg in B346, then copy down: =INDEX($A$346:$A$375,(ROWS($1:1)+1)/2) Above tested ok here. Celebrate your success, click the YES button below and in TM's response -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "Dingerz" wrote: I have got it to work =INDEX($A$346:$A$375,1/2) But its not doing what i wanted and only copying 1 cell over and over again |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot open one particula worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Keeping the correct cells when making a formula? | Excel Worksheet Functions | |||
| making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
| automatically making a copy of a sheet | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Threaded Mode
