LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default Copy values to a different cell

In C1 I want the formula (to be pulled down 100 rows), If A1B1 then
B1=value(A1), else B1 value remains unchanged. My attempts to do this have
all ended in failure. I could have this formula in column B, but I need to
see (and subsequently operate upon) the values, not the formula.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and transpose basing on cell values balu Excel Discussion (Misc queries) 0 February 10th 08 08:35 AM
Auto copy single values to another cell DDavid Excel Discussion (Misc queries) 5 September 27th 07 02:11 PM
copy graphs values in a cell bluepill Charts and Charting in Excel 3 June 29th 06 05:45 PM
Copy Values in a cell (derived from formulas) Ali Excel Worksheet Functions 2 January 19th 06 02:18 PM
How can I copy values from one cell in a column down to the next c GSingh Excel Discussion (Misc queries) 9 August 16th 05 11:18 AM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"