| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get Row # in formula?
I have several rows with the same formula but they are seperated, in some
cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
You may not be able to drag it, but if you copy row13 formula and go to row
20 it updates does it not? -- HTH Bob "DaveR" wrote in message ... I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
you might want to try =b13*sum(c13:e13)
and then copy "Bob Phillips" wrote: You may not be able to drag it, but if you copy row13 formula and go to row 20 it updates does it not? -- HTH Bob "DaveR" wrote in message ... I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
and?
-- HTH Bob "pmartglass" wrote in message ... you might want to try =b13*sum(c13:e13) and then copy "Bob Phillips" wrote: You may not be able to drag it, but if you copy row13 formula and go to row 20 it updates does it not? -- HTH Bob "DaveR" wrote in message ... I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
Copy and paste will work for want you want
or ctrl+C for copy and ctrl+V for paste -- Wag more, bark less "DaveR" wrote: I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
Thanks. I didn't realize that if I were to copy that cell and paste in
another that the row identity would come too. That got it. Dave "Brad" wrote: Copy and paste will work for want you want or ctrl+C for copy and ctrl+V for paste -- Wag more, bark less "DaveR" wrote: I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
You're welcome
-- Wag more, bark less "DaveR" wrote: Thanks. I didn't realize that if I were to copy that cell and paste in another that the row identity would come too. That got it. Dave "Brad" wrote: Copy and paste will work for want you want or ctrl+C for copy and ctrl+V for paste -- Wag more, bark less "DaveR" wrote: I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get Row # in formula?
how can I write a formula to populate the "13" or "20" automatically
for whatever row I am in? Just to be different... Add a range name formula. This macro will do it for you... ActiveWorkbook.Names.Add Name:="fx", RefersToR1C1:= _ "=RC2*SUM(RC3:RC5)" Now, in a cell in any column(except B:E), just enter the formula =Fx = = = = = = = HTH :) Dana DeLouis On 3/12/2010 8:53 AM, DaveR wrote: I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula down to other rows. Ex. While in row 13: B13*C13+B13*D13+B13*E13 While in row 20: B20*C20+.... how can I write a formula to populate the "13" or "20" automatically for whatever row I am in? Thanks, Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
