#1
|
|||
|
|||
Sorting by certain criteria
Suppose I have two tables. One consists of these columns: 'Friends' and some other information on my friends. The other table consists of a few columns that are the countries which my friends reside in. The 'Friends' column will have a list of my friends' names, while the country columns will each contain my friends residing there. How would I go about to sort the first table base on the 'Friends' column such that they will be grouped into which country they are from?
I am using Office 97 at my workplace. |
#2
|
||||
|
||||
Welcome to the forum.
To use Excel's built-in sort feature, you'll need to create an extra column on your first table and then use VLOOKUP (or other similar function) to pull in the country from the second table. Then you can sort by that column. If you do not want to use an extra column then I think you would have to write some VBA code to sort the data for you. |
#3
|
|||
|
|||
Thanks Colin, it works.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search Folder sent to criteria | markstro | Outlook | 0 | 12-20-2011 02:47 PM |
Forgotten Sort and Filter Criteria | rbdmg | Mail Merge | 0 | 10-31-2011 09:14 PM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Criteria in Outlook Search | Nancy Grams | Outlook | 0 | 11-12-2009 03:03 PM |
Multiple criteria in SUMIF? | pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |