| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do the following copying?
Hi,
I have a spreadsheet in which cell C2 contains =A1, cell C3 contains =A3, cell C4 contains =A5 may I know what operation I can do, without using macro, such that cell C5 contains =A7, cell C6 contains =A9, cell c7 contains =A11 etc? Thank you. Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to do the following copying?
"cyberdude" wrote:
I have a spreadsheet in which cell C2 contains =A1, cell C3 contains =A3, cell C4 contains =A5 may I know what operation I can do, without using macro, such that cell C5 contains =A7, cell C6 contains =A9, cell c7 contains =A11 etc? Try a different approach. Enter the following formula in C2 and copy down: =INDEX(A:A,2*ROWS($C$2:C2)-1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Copying File or Folder message when copying file to CD | Excel Programming | |||
| Copying sheets without copying named ranges | Excel Programming | |||
| Which is faster, copying range to another set of ranges or copying tomemory? | Excel Programming | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| TextBox copying not like windows copying, heh? | Excel Programming | |||
Linear Mode
