Is there a MOVE operator like IF, AND, etc?
 

--
SgtBob

Is there a MOVE operator like IF, AND, etc?
 

And what would such an operator do?


In article ,
Bob wrote:

Is there a MOVE operator like IF, AND, etc?
 

There is no MOVE

I can't think of a use for a MOVE so
Explain what you'd like to do

Steve

On Fri, 08 Sep 2006 22:25:02 +0100, Bob
wrote:

Is there a MOVE operator like IF, AND, etc?
 

No.

Unless you have a typo and meant MODE

Worksheet functions cannot move data.

They can only pull from another source.


Gord Dibben MS Excel MVP

On Fri, 8 Sep 2006 14:25:02 -0700, Bob wrote:

Is there a MOVE operator like IF, AND, etc?
 

Describe what you want done.

I'm sure someone will find a solution.


Gord

On Fri, 08 Sep 2006 14:45:18 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

No.

Unless you have a typo and meant MODE

Worksheet functions cannot move data.

They can only pull from another source.


Gord Dibben MS Excel MVP

On Fri, 8 Sep 2006 14:25:02 -0700, Bob wrote:


Gord Dibben MS Excel MVP

Is there a MOVE operator like IF, AND, etc?
 

Well, I have a specific use for the missing 'MOVE' command. As in the old
days, we would use a 'PUT' or 'POKE' command. Anyway, we have a string of
DDE data coming into our spreadsheet in two cells (say A1 and B1). The data
is scrolling through a series of 10 particle counters but not always in the
same sequence. Hence, the A1 cell is the sensor ID and cell B1 is the raw
data. As the data comes in we test it for ID and would like to place it in a
cell specific for that ID. The easiest approach (If we could do it) would be
the statement "=if(A1=X then DX=value of B1 else leave DX as is)" The idea
being to move the data to permenant cells for further manipulation. Right
now the 'else' feature of the if command forces a change to the target cell.
Need to have a sensor specific location for the data to work with. We have a
work around that uses circular logic but that is not very elegant.

"Gord Dibben" wrote:

Describe what you want done.

I'm sure someone will find a solution.


Gord

On Fri, 08 Sep 2006 14:45:18 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

No.

Unless you have a typo and meant MODE

Worksheet functions cannot move data.

They can only pull from another source.


Gord Dibben MS Excel MVP

On Fri, 8 Sep 2006 14:25:02 -0700, Bob wrote:


Gord Dibben MS Excel MVP