Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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

All times are GMT -7. The time now is 04:02 PM.


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