|
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. |
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. |
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. |
| All times are GMT +1. The time now is 10:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com