View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny Johnny is offline
external usenet poster
 
Posts: 126
Default There should be a swap function for 2 values

How often does it happen within a table that you need to copy a value to a
cell, but there is already data inside it. So you need to copy the end field
to a third cell, then put the original value to the cleared cell and then
copy removed data somewhere else.

A great function would be SWAP - where you can simply swap the values
between 2 cells. that would save several steps and would give Excel a lead in
functionality and comfort.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc