Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2012, 11:30 PM
randenius randenius is offline Sorting by certain criteria Windows XP Sorting by certain criteria Office 2000
Novice
Sorting by certain criteria
 
Join Date: Jun 2012
Posts: 2
randenius is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 06-07-2012, 07:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Sorting by certain criteria Windows 7 32bit Sorting by certain criteria Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 06-11-2012, 02:18 AM
randenius randenius is offline Sorting by certain criteria Windows XP Sorting by certain criteria Office 2000
Novice
Sorting by certain criteria
 
Join Date: Jun 2012
Posts: 2
randenius is on a distinguished road
Default

Thanks Colin, it works.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Sorting by certain criteria 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
Sorting by certain criteria Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft