Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change column references when filling down a formula
I want to drag this formula down 12 cells (months)
='Total Commissions'!B$2 ='Total Commissions'!C$2 I know that the "$" will make the Row Reference static, but how do I get the Column Reference to change |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change column references when filling down a formula
Hi Bclancy,
one way is create a list with 1,2,3...12 in one column suppose it starts on g1 thu G12 so the formula could be: =indirect(address(2,col()+g1,1,1,"Total Commissions") and copu it down hope this helps Regards from Brazil Marcelo "bclancy12" escreveu: I want to drag this formula down 12 cells (months) ='Total Commissions'!B$2 ='Total Commissions'!C$2 I know that the "$" will make the Row Reference static, but how do I get the Column Reference to change |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change column references when filling down a formula
I would probably use the indirect function Check help for details
=indirect("'Total commissions'!R2C"&(row()+X),1) where X is the value needed to get the appropriate column reference in the first equation cell "bclancy12" wrote: I want to drag this formula down 12 cells (months) ='Total Commissions'!B$2 ='Total Commissions'!C$2 I know that the "$" will make the Row Reference static, but how do I get the Column Reference to change |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change column references when filling down a formula
Hi
One way =INDIRECT("'Total Commissions'!"&CHAR(ROW(66:66))&"2") -- Regards Roger Govier "bclancy12" wrote in message ... I want to drag this formula down 12 cells (months) ='Total Commissions'!B$2 ='Total Commissions'!C$2 I know that the "$" will make the Row Reference static, but how do I get the Column Reference to change |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
Need Help With Formula (Disregard my display name can't change) | Excel Discussion (Misc queries) | |||
Right Filling A Formula Whilst Keeping A Static Column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) |