Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Relative Reference
Hi,
My question is I have a row and a column of values. I am trying to multiply the row by column and display it in a row format. eg Row 3 5 2 5 Column 1 4 5 6 I want the product to be displayed as 3 20 10 30 by using relative reference. It doesnt work for me. Pl. let me know if anyone has any idea. Thanks |
#2
|
|||
|
|||
Relative Reference
Hi!
Assume: A1:D1 = 3;5;2;5 A3:A6 = 1;4;6;5 =A1*INDEX($A3:$A6,COLUMNS($A:A)) Copy across as needed. Biff "Hari" wrote in message ... Hi, My question is I have a row and a column of values. I am trying to multiply the row by column and display it in a row format. eg Row 3 5 2 5 Column 1 4 5 6 I want the product to be displayed as 3 20 10 30 by using relative reference. It doesnt work for me. Pl. let me know if anyone has any idea. Thanks |
#3
|
|||
|
|||
Relative Reference
Let's say your row is in cells B1:E1 and your column is in cells A2:A6.
Select cells B2:E2, type =B1:E1*TRANSPOSE(A2:A5) and hold the Control and Shift keys while you press Enter. "Hari" wrote: Hi, My question is I have a row and a column of values. I am trying to multiply the row by column and display it in a row format. eg Row 3 5 2 5 Column 1 4 5 6 I want the product to be displayed as 3 20 10 30 by using relative reference. It doesnt work for me. Pl. let me know if anyone has any idea. Thanks |
#4
|
|||
|
|||
Relative Reference
Hi, How about something like this: Say you have in column A starting in A2 (1,4,5,6) and in row 1 starting in B1 (3,5,2,5) then the formula would be: in column B =B1*INDIRECT("A"&ROW(2:2)+COLUMN()-2) copied across HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=479311 |
#5
|
|||
|
|||
Relative Reference
"Hari" wrote in message ... Hi, My question is I have a row and a column of values. I am trying to multiply the row by column and display it in a row format. You could use array formula with transpose function. Select 4 cells in row, and write a formula: =A1:D1*TRANSPOSE(A2:A5), and press ctrl-shift-enter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Recording new excel macro, relative reference button doesn't show | New Users to Excel | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
"relative reference" question | Excel Discussion (Misc queries) | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) |