Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to correlate rows/columns
I have a row of formulas in one sheet that need to refer to a column
of values in another. That is, in the formula sheet, I have a row like this: A1: "=Data!A1" B1: "=Data!A2" C1: "=Data!A3" D1: "=Data!A4" Is there an easy way to get this to work so that I can either copy and paste or use Fill Right to generate more formulas in the row, and have them refer to the corresponding column values in the data sheet? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to correlate rows/columns
This will work based on your posted sample:
=INDEX(Data!$A:$A,COLUMN()) Copy across as needed. If your posted sample is just a made-up example: =INDEX(Data!$A5:$A100,COLUMNS($A:A)) Adjust the range as needed: Data!$A5:$A100 Biff wrote in message oups.com... I have a row of formulas in one sheet that need to refer to a column of values in another. That is, in the formula sheet, I have a row like this: A1: "=Data!A1" B1: "=Data!A2" C1: "=Data!A3" D1: "=Data!A4" Is there an easy way to get this to work so that I can either copy and paste or use Fill Right to generate more formulas in the row, and have them refer to the corresponding column values in the data sheet? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Any formula to tranpose columns into rows ? | Excel Discussion (Misc queries) | |||
Pivot table could allow to correlate text labels. | Excel Discussion (Misc queries) | |||
Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21 | Excel Worksheet Functions | |||
Static formula when inserting new rows/columns? | Excel Discussion (Misc queries) | |||
Lines on chart don't correlate to values being charted | Charts and Charting in Excel |