Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob - 08 Sep 2006 22:25 GMT
Signature

SgtBob

JE McGimpsey - 08 Sep 2006 22:31 GMT
And what would such an operator do?
SteveW - 08 Sep 2006 22:34 GMT
There is no MOVE

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

Steve
Gord Dibben - 08 Sep 2006 22:45 GMT
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
Gord Dibben - 08 Sep 2006 22:46 GMT
Describe what you want done.

I'm sure someone will find a solution.

Gord

>No.
>
[quoted text clipped - 5 lines]
>
>Gord Dibben  MS Excel MVP

Gord Dibben  MS Excel MVP
TonyJ03 - 21 Nov 2006 23:48 GMT
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.

> Describe what you want done.
>
[quoted text clipped - 13 lines]
>
> Gord Dibben  MS Excel MVP

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.