| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy values to a different cell
A formula in C1 can not change the value in B1.
If in C1 you put the formula =MAX(A1,B1), you could then copy the result and paste special values into column B. -- David Biddulph "Kanga 85" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy values to a different cell
Thanks David
"David Biddulph" wrote: A formula in C1 can not change the value in B1. If in C1 you put the formula =MAX(A1,B1), you could then copy the result and paste special values into column B. -- David Biddulph "Kanga 85" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and transpose basing on cell values | Excel Discussion (Misc queries) | |||
| Auto copy single values to another cell | Excel Discussion (Misc queries) | |||
| copy graphs values in a cell | Charts and Charting in Excel | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| How can I copy values from one cell in a column down to the next c | Excel Discussion (Misc queries) | |||
Linear Mode
