Sorting

B

Bruce Transue

I have 2 columns, "Salesman" & "Contractors" I want to
get a list of all the "Contractors" for each "Salesman".
When I try to sort, it doesn't keep the "contractor"
linked to the "Salesman". How do I keep the correct
Salesman with the contractor?
Ex.: Bob - alalalalal
bob - lkjnfdpjneop
joe - f;fdknj;elk
etc.
 
G

Guest

ARE YOU SURE THAT BOTH COLUMNS ARE HIGHLIGHTED WHEN YOU
SORT? YOU COULD ALSO USE THE FILTER FUNCTION UNDER DATA /
FILTER / AUTO... MIGHT BE EASIER.
 

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

Assigning an overarching owner to a task 0
Summing a ranking of several categories 4
Counting sales 1
Finding Unique/Duplicates 5
Count values 2
Create unique list of names from list of duplicates and that arefound within another range 1
Comparing more than two 4
Combo Box Sorting 2

Top