Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using absolute functions "$" to populate a column from a row
Hello,
Excel 2007 Is there anyway I can automatically populate a column from a row using "$" Absolute functions in the formula, to save having to create a new formula to poulate each column cell. Thank for your help -- Regards Repurr |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using absolute functions "$" to populate a column from a row
Hi,
suppose the row data starts in B1 and you enter the following formula in A2 and copy down =OFFSET($A$1,,ROW(A1)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Repurr" wrote: Hello, Excel 2007 Is there anyway I can automatically populate a column from a row using "$" Absolute functions in the formula, to save having to create a new formula to poulate each column cell. Thank for your help -- Regards Repurr |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using absolute functions "$" to populate a column from a row
Hi,
Thanks for your reply. Yes your forumla works as described, my situation is slightly different, let me explain; The row of data is on 1 spreadsheet which starts at column E with data not required to be included in the formula in columns A - D. I have tried the forumlation you detailed, sadly only producing 0.00 socres. Your help on this is much appreciated. -- Regards Repurr "Shane Devenshire" wrote: Hi, suppose the row data starts in B1 and you enter the following formula in A2 and copy down =OFFSET($A$1,,ROW(A1)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Repurr" wrote: Hello, Excel 2007 Is there anyway I can automatically populate a column from a row using "$" Absolute functions in the formula, to save having to create a new formula to poulate each column cell. Thank for your help -- Regards Repurr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green") | Excel Worksheet Functions | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
"Absolute" questions when autofilling-dragging down the column not | Excel Worksheet Functions |