| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a MOVE operator like IF, AND, etc?
-- SgtBob |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is there a MOVE operator like IF, AND, etc?
And what would such an operator do?
In article , Bob wrote: |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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: |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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: |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
