ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula row to data column (https://www.excelbanter.com/excel-discussion-misc-queries/250461-formula-row-data-column.html)

Andrew

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,



ADB_Seeker

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,



T. Valko

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,






All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com