Values are not visible
I have a worksheet with column "c" showing a result of a formula. I'm just
simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
Values are not visible
Not sure what's happening, but if you want to link to col C,
you could try this in say, E1: =IF(C1="","",C1) Copy E1 down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Milan" wrote: I have a worksheet with column "c" showing a result of a formula. I'm just simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
Values are not visible
Milan
When you move data, which is the results of a formula, with the drag handle (plus"+" sign) those references that are not absolute will increment to the appropriate cells when you drag. If you want to move the data it would be better to copy then Paste special/values. Mike Rogers "Milan" wrote: I have a worksheet with column "c" showing a result of a formula. I'm just simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
All times are GMT +1. The time now is 02:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com