| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate path and file string for external reference | Excel Worksheet Functions | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| Concatenate a reference to named ranges in other workbook | Excel Worksheet Functions | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
