How do I link two columns for sorting?

  • Thread starter Danielle Madril
  • Start date
D

Danielle Madril

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.
 
M

Marcelo

Hi Daniellie

select the range go to DATA menu and sort

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Danielle Madril" escreveu:
 
D

David Biddulph

Danielle Madril said:
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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Center-Autolink column fields 0
How to center adjust text above and image in a two column document. 1
Two columns followed by single page-width column on same page 0
Identifying more than one item in a list 8
Autonumber field in Excel that behaves the same as Access 0
Adding a big matrix in Word 2013 5
How to sort entire spreadsheet by one column sort 5
Format column widths from one table to a separate table on same page 1

Top