Cell Reference and Concatenate
 

For F5, the cell is already using concatenate but here's what I'm wanting to do. I want F5 to contain information from the 2nd row (i.e. 35% and 11/13/2010). However, when i copy and paste the formula from F1 to F5, F5 registers the values contained in C5 and D5 and not the values on C2, and D2). Any help please.


Pls see the attached picture.

Cell Reference and Concatenate
 

On Tue, 6 Nov 2012 17:48:18 +0000, managingcrap wrote:


For F5, the cell is already using concatenate but here's what I'm
wanting to do. I want F5 to contain information from the 2nd row (i.e.
35% and 11/13/2010). However, when i copy and paste the formula from F1
to F5, F5 registers the values contained in C5 and D5 and not the values
on C2, and D2). Any help please.


Pls see the attached picture.


+-------------------------------------------------------------------+
|Filename: untitled.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=666|
+-------------------------------------------------------------------+

Use absolute references in your formula: $C$2 instead of C2
Look at Absolute References in HELP