Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
There should be a swap function for 2 values
Hi I would try the option named scenario under the menu tool. see attach document. +-------------------------------------------------------------------+ |Filename: scenario.zip | |Download: http://www.excelforum.com/attachment.php?postid=4998 | +-------------------------------------------------------------------+ -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=559355 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function: Ignore Mimimum and Maximum Values | Excel Worksheet Functions | |||
Auto-prompt/complete (?) function for number values | Excel Discussion (Misc queries) | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions |