Excel formula to move certain fields

K

kimtruss

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"
 
P

PAR

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")
 
K

kimtruss

Have entered this formula, but does not work. I want the data in column a to
move to column c regardless of what the cell content of column a is. Any
ideas?
 
P

PAR

Can you be more specific about your table set up and what you are trying to
accomplish? If you want to move data, you can cut and then insert cut cells.
Or, have enter =A2 in cell C2.
 
G

Gord Dibben

Formulas cannot "move" data.

Formulas can only return results into the cell(s) in which they are written.

To move data you would require VBA code, either event code or a macro routine.


Gord Dibben MS Excel MVP
 
Top