| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula row to data column
how do I make it so that I can copy a formula row ways and only pull data in
one column. Thank you for your help, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula row to data column
If I'm understanding your question correctly, you need only reference the
formula in the cell in which you want the data to appear. You may need to make the formula cell references absolute. This can be done with the F4 key. If this is helpful, please click on the Yes below. Thank you "Andrew" wrote: how do I make it so that I can copy a formula row ways and only pull data in one column. Thank you for your help, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula row to data column
How about providing some details? Where is the data you want to reference
and where do you want to put it? -- Biff Microsoft Excel MVP "Andrew" wrote in message ... how do I make it so that I can copy a formula row ways and only pull data in one column. Thank you for your help, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to copy data from every 4th column | Excel Discussion (Misc queries) | |||
| how do i copy data and formula from a column to a row in another? | Excel Worksheet Functions | |||
| Copy Sum formula to different row but use same column data | Excel Worksheet Functions | |||
| How do I split data in a column (formula)? | Excel Discussion (Misc queries) | |||
| formula to determine the first column containing any data | Excel Worksheet Functions | |||
Linear Mode
