Posted to microsoft.public.excel.worksheet.functions

Gary

external usenet poster

Posts: 143

swap

I want to swap values of two cells. can anyone help me on that? Eg. Cell A1
contains the value 20 & cell A2 contains the value 100. I want 100 on A1 &
20 on A2.

Thanks
Gary

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
There should be a swap function for 2 values	Johnny	Excel Discussion (Misc queries)	1	July 7th 06 05:56 PM
Swap the X and Y axes	LAUR	Charts and Charting in Excel	1	May 15th 06 07:21 PM
Text Strings Swap	Mzansi	Excel Worksheet Functions	1	November 29th 05 11:04 AM
Swap contents of two cells	Sterling	Excel Discussion (Misc queries)	3	October 20th 05 06:04 PM
Swap data from one cell to another	Brooks W.	Excel Worksheet Functions	2	May 16th 05 03:50 PM

All times are GMT +1. The time now is 07:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us