Excel formula to move certain fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimtruss - 21 Apr 2006 02:57 GMT

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"

Reply to this Message

PAR - 21 Apr 2006 03:37 GMT

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," ")

> 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"

Reply to this Message

kimtruss - 21 Apr 2006 04:11 GMT

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?

> So, you have data in column A and you want to move data to Column C if the
> value =x?
[quoted text clipped - 4 lines]
> > 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"

Reply to this Message

PAR - 21 Apr 2006 05:56 GMT

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.

> 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
[quoted text clipped - 8 lines]
> > > 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"

Reply to this Message

Gord Dibben - 21 Apr 2006 19:49 GMT

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

>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
[quoted text clipped - 8 lines]
>> > 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"

Reply to this Message