| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying vertical references horizontally
Sorry, basic question, searched for answer but couldn't find quickly.
A B C D E 1 10 2 20 3 30 4 =E1*3% How do I copy the formula in A4 across so that the next one is E2*3%? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying vertical references horizontally
Hi Christina:
In A4 enter: =INDIRECT("E" & COLUMN())*3% and copy across -- Gary's Student "Christina" wrote: Sorry, basic question, searched for answer but couldn't find quickly. A B C D E 1 10 2 20 3 30 4 =E1*3% How do I copy the formula in A4 across so that the next one is E2*3%? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying vertical references horizontally
Another way:
=INDEX($E:$E,COLUMNS($A:A))*3% -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Gary''s Student" wrote in message ... Hi Christina: In A4 enter: =INDIRECT("E" & COLUMN())*3% and copy across -- Gary's Student "Christina" wrote: Sorry, basic question, searched for answer but couldn't find quickly. A B C D E 1 10 2 20 3 30 4 =E1*3% How do I copy the formula in A4 across so that the next one is E2*3%? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
| Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
| formula references vertical cells in a separate worksheet | Excel Worksheet Functions | |||
| Can you extend a formula horizontally while the data is vertical | Excel Discussion (Misc queries) | |||
| copying data horizontally | Excel Worksheet Functions | |||
Hybrid Mode
