Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I match data about countries drawn from two database queries?
Hi, From a database, I have imported (into Excel) two lists of statistics by country: (list a) the 20 countries with the largest number of cell phone users, and (list b) the 20 countries with the highest percentage of cell phone users. I want to match these two lists by country so that the names and their corresponding statistical information will appear in the same row in every case where a country exists in both lists. For those countries that don’t appear in both lists, I would like for each of them, along with its corresponding statistical information, to appear in its own row. Does Excel 2003 have a function or tool that can reorganize the data in this way? Thanks, tettrick -- tettrick ------------------------------------------------------------------------ tettrick's Profile: http://www.excelforum.com/member.php...o&userid=14356 View this thread: http://www.excelforum.com/showthread...hreadid=398855 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |