November 19, 2008 03:18am pst

1. saurabh726 161,298
2. zorvek 130,037
3. rorya 115,017
4. matthews... 110,682
5. byundt 72,462
6. nutsch 57,414
7. patrickab 46,622
8. chris_bot... 39,872
9. jeverist 32,124
10. epaclm 24,500
11. dj88 19,600
12. jpaulino 19,100
13. WJReid 15,875
14. brettdj 15,200
15. webtubbs 13,700
16. ahammar 13,280
17. irudyk 13,243
18. spattewar 12,952
19. Merch_Ops 11,350
20. RobSamp... 11,300
21. gtgloner 11,202
22. folderol 9,375
23. StellanRo... 9,000
24. nike_golf 8,414
25. kacor 8,000
25. jppinto 8,000

1. rorya 177,316
2. saurabh726 168,298
3. zorvek 165,517
4. matthews... 153,701
5. byundt 97,637
6. patrickab 64,977
7. jeverist 57,724
8. nutsch 57,414
9. chris_bot... 48,412
10. roos01 39,716
11. webtubbs 29,680
12. epaclm 28,450
13. jpaulino 23,700
14. dj88 19,600
15. WJReid 17,875
16. RobSamp... 17,540
17. ahammar 17,352
18. brettdj 15,200
19. gtgloner 14,502
20. spattewar 13,952
21. irudyk 13,243
22. StellanRo... 12,500
23. mvbernot 11,700
24. kacor 11,600
25. folderol 11,375

04.16.2008 at 06:56PM PDT, ID: 23329567

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

Compare and merge data of two columns from two sheets to thrid sheet

Asked by J-W-O in Spreadsheet Software, Microsoft Excel Spreadsheet Software

Tags: Office, Excel, 2003, columns, compare, Microsoft Excel Spreadsheet Software, Spreadsheet Software,

Using MS Excel 2003, I need to compare sheet1, column a, with sheet2, column a, and combine ALL unique values to create a list on sheet 3. For example,

NOTE: sheet1, column A does not contain the same number of items as sheet2, column A

SHEET1 SHEET2
A A
A/C DUCT & INSULATION Total        A/C DUCT & INSULATION Total
AEARO COMPANY Total        AEARO COMPANY Total
ALLISON TRANSMISSION Total        ALLISON TRANSMISSION Total
ASIA DEVELOPMENT CAPITAL Total        ASIA DEVELOPMENT CAPITAL Total
AVMED Total        AVON AUTOMOTIVE Total
AVON AUTOMOTIVE Total        BELLSOUTH Total
BARTECH - DETROIT Total        BENTELER AUTOMOTIVE CORP Total
BELLSOUTH Total        BLUE CARE NETWORK Total
BENTELER AUTOMOTIVE CORP Total        BLUE CROSS AND BLUE SHIELD Total
BLUE CARE NETWORK Total        BORG WARNER Total
BLUE CROSS AND BLUE SHIELD Total        BURTEK INC Total
BORG WARNER Total        CARHARTT Total
BURTEK INC Total        CHRYSLER Total
CARHARTT Total        CITY OF DETROIT -COMPUWARE Total
CHRYSLER Total        COMPREHENSIVE HEALTH SERVICES Total
CITY OF DETROIT -COMPUWARE Total        CRANKSHAFT US BROACH Total
COMP BENEFITS Total        CUMMINS Total
COMPREHENSIVE HEALTH SERVICES Total       DANA CORPORATION Total
CRANKSHAFT US BROACH Total        DAYTON POWER & LIGHT COMPANY Total
CUMMINS Total        DELPHI Total
CYLTEC Total        D.A. STUART COMPANY Total
DANA CORPORATION Total
DAYTON POWER & LIGHT COMPANY Total
DELPHI Total
DELTA FAUCET COMPANY Total
DENTEMAX Total
DETROIT EDISON Total
DUKE ENERGY Total

SHEET 3
A/C DUCT & INSULATION Total
AEARO COMPANY Total
ALLISON TRANSMISSION Total
ASIA DEVELOPMENT CAPITAL Total
AVMED Total
AVON AUTOMOTIVE Total
BARTECH - DETROIT Total
BELLSOUTH Total
BENTELER AUTOMOTIVE CORP Total
BLUE CARE NETWORK Total
BLUE CROSS AND BLUE SHIELD Total
BORG WARNER Total
BURTEK INC Total
CARHARTT Total
CHRYSLER Total
CITY OF DETROIT -COMPUWARE Total
COMP BENEFITS Total
COMPREHENSIVE HEALTH SERVICES Total
CRANKSHAFT US BROACH Total
CUMMINS Total
CYLTEC Total
D.A. STUART COMPANY Total
DANA CORPORATION Total
DAYTON POWER & LIGHT COMPANY Total
DELPHI Total
DELTA FAUCET COMPANY Total
DENTEMAX Total
DETROIT EDISON Total
DUKE ENERGY Total

Thanks for your help!

Start Free Trial

Keywords: Compare and merge data of two colum…

	Title
1	Irregular Heart Beat
2	U. S. Energy Policy
3	Merge multiple sheets ?
4	Merge Excel Sheets
5	Merge a xml TLIST
6	Define: Energy

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628

Compare and merge data of two columns from two sheets to thrid sheet

Asked by J-W-O in Spreadsheet Software, Microsoft Excel Spreadsheet Software

Tags: Office, Excel, 2003, columns, compare, Microsoft Excel Spreadsheet Software, Spreadsheet Software,

About this solution