| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a formula to move data to a different cell
I am trying to create a elimination ladder and want to ceate a formula to
move names from one cell to another when an X is placed in a certain cell. Example when cell C2 is checked as X name in C1 moves to F1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I create a formula to move data to a different cell
Formulae return values to their calling cells - they can't change other
cells. Assuming C1 and D1 have the two names and the X will go in C2 or D2: =IF(C2="X",C2,IF(D2="X",D2,"") In article , Leland wrote: I am trying to create a elimination ladder and want to ceate a formula to move names from one cell to another when an X is placed in a certain cell. Example when cell C2 is checked as X name in C1 moves to F1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I create a formula to move data to a different cell
in C1
=if(c2="X","","Name in C1") in F1 =if(c2="X",C1,"") -- Regards, Tom Ogilvy "Leland" wrote in message ... I am trying to create a elimination ladder and want to ceate a formula to move names from one cell to another when an X is placed in a certain cell. Example when cell C2 is checked as X name in C1 moves to F1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a formula using part of the data in 1 cell? | Excel Worksheet Functions | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
| How do I move data without changing an associated formula? | Excel Discussion (Misc queries) | |||
| create macro to move label type data to column data | Excel Programming | |||
Linear Mode
