ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I copy a function for comparison but keep first cell value. (https://www.excelbanter.com/excel-worksheet-functions/14323-how-do-i-copy-function-comparison-but-keep-first-cell-value.html)

N'wester

How do I copy a function for comparison but keep first cell value.
 
I want to run a regression comparing various columns to a single column. I
want to be able to drag copy the format while keeping the first column the
same. I can do it by replacing all the column variables individually but
don't know how to do it automatically.


All times are GMT +1. The time now is 08:39 PM.

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