Menu

How do I link two columns for sorting?

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.misc

David Biddulph David Biddulph is offline

David Biddulph is offline

external usenet poster

Posts: 618

Default

How do I link two columns for sorting?

"Danielle Madril" <Danielle wrote in
message ...
How do I link two columns for sorting alphabetically? I have two columns
of
drugs. One has the drug listing by generic name. The other lists the
same
drugs by trade name. I want to link column A to coumn B, so the
corresponding drug names are always side by side (Lasix is always next to
Furosemide). The I want to sort the columns alphabetically in Column A or
in
Column B, but I always want Lasix linked to Furosemide. Thanks.

Select the whole range (both columns) before you sort.
--
David Biddulph

Reply With Quote

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
How do I create a link between columns from a data chart?	Sara	Excel Discussion (Misc queries)	1	June 2nd 06 06:51 PM
How do I wrap Excel columns in a printout?	R2	Excel Discussion (Misc queries)	1	April 1st 06 09:47 AM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns	Sam via OfficeKB.com	Excel Worksheet Functions	4	July 14th 05 09:15 PM
How do I copy a link that is in columns to another worksheet down.	Bolynx	Excel Discussion (Misc queries)	1	March 30th 05 09:15 PM
How do I link columns so data flows from 1 column to another like.	M. Frazel	Excel Discussion (Misc queries)	1	January 14th 05 04:17 PM

All times are GMT +1. The time now is 12:39 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement