Posted to microsoft.public.excel.misc

Tom

Posts: n/a

Sorting columns

This is probably pretty standard but how to I sort columns containing the
same data but in different orders. eg. Column A has 1-10 listed in ascendinf
order, and column B has them listed in descending order, how could I sort
them so that 1 and 1, 2 and 2 etc pair up?

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
Sorting alpha in two columns	SteveC	Excel Discussion (Misc queries)	2	March 24th 06 01:56 PM
Sorting columns with expressions	et	New Users to Excel	2	October 10th 05 09:54 PM
sorting data across multiple columns	Spiderman	Excel Discussion (Misc queries)	2	October 6th 05 11:55 PM
Columns	FemIce	Excel Discussion (Misc queries)	1	September 28th 05 09:29 AM
Sorting rows AND columns	3D	Excel Worksheet Functions	2	January 7th 05 02:15 AM

All times are GMT +1. The time now is 05:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us