| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match 2 sheet and build table
Hi all, I have a document I need to do. I have 2 xls doc sheets. Both docs have 2 colums, 1st is the US state, the second is the City. I need to build a table that will tell me how many rows (State and City) matches between the 2 sheets and if possible: Build a table showing how many matches and how many dont, list the ones that dont, build a chart How can I do this? I dont even know where to start.... The 1 sheet is the master, has 200 or so rows that the other sheet must match against. Thanks for any help you can provide me. -- npereira ------------------------------------------------------------------------ npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799 View this thread: http://www.excelforum.com/showthread...hreadid=570506 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I build a excel sheet that counts item in an inventory | Excel Worksheet Functions | |||
| How do i build a search table in excel | Excel Worksheet Functions | |||
| Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
| Is there a way to build a timeline PPT spread sheet from excel | Excel Worksheet Functions | |||
| Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
Threaded Mode
