回复:Is there an excel function to compare two lists?

回答: Is there an excel function to compare two lists?greendust2013-02-23 11:09:06

 

Company Symbol: Sector NYSE NASDAQ
3M Industrials MMM  
Abbott Laboratories Health Care ABT  
Abercrombie & Fitch Consumer Discretionary ANF  
ACE Financials ACE  
Adobe Systems Information Technology   ADBE
Advanced Micro Devices Information Technology AMD  
AES Utilities AES  
Aetna Health Care AET  
Affiliated Computer Services Information Technology ACS  
AFLAC Financials AFL  
Agilent Technologies Information Technology A  
Air Products & Chemicals Materials APD  
Akamai Technologies Information Technology   AKAM
Alcoa Materials AA  
Allegheny Energy Utilities AYE  
Allegheny Technologies Materials ATI  
Allergan Health Care AGN  
Allied Waste Industries Industrials AW  
Allstate Financials ALL  
Altera Information Technology   ALTR
Altria Group Consumer Staples MO  
Amazon.com Consumer Discretionary   AMZN
Ambac Financial Group Financials ABK  
Ameren Utilities AEE  
American Capital Strategies Financials   ACAS
American Electric Power Utilities AEP  
American Express Financials AXP  
American International Group Financials AIG  
American Standard Industrials ASD  
American Tower Telecommunications Services AMT  
Ameriprise Financial Financials AMP  
AmerisourceBergen Health Care ABD  
Amgen Health Care   AMGN
Anadarko Petroleum Energy APC  
Analog Devices Information Technology ADI  
Anheuser-Busch Consumer Staples BUD  
Aon Financials AOC  
Apache Energy APA  
Apartment Investment and Management Financials AIV  
Apollo Group Consumer Discretionary   APOL
Apple Information Technology   AAPL
Applied Biosystems Group Health Care ABI  
Applied Materials Information Technology   AMAT
Ashland Materials ASH  
Assurant Financials AIZ  
AT&T Telecommunication Services T  
Autodesk Information Technology   ADSK
Automatic Data Processing Information Technology ADP  
AutoNation Consumer Discretionary AN  
AutoZone Consumer Discretionary AZO  
AvalonBay Communities Financials AVB  
Avery Dennison Industrials AVY  
Avon Products Consumer Staples AVP  
Baker Hughes Energy BHI  
Ball Materials BLL  
Bank of America Financials BAC  
Bank of New York Mellon Corp. Financials BK  
Barr Pharmaceuticals Health Care BRL  
Baxter International Health Care BAX  
BB&T Financials BBT  
Bear Stearns Financials BSC  
Becton, Dickinson and Co. Health Care BDX  
Bed Bath & Beyond Consumer Discretionary   BBBY
Bemis Company Materials BMS  
Best Buy Co. Consumer Discretionary BBY  
Big Lots Consumer Discretionary BIG  
Biogen Idec Health Care   BIIB
BJ Services Energy BJS  
Black & Decker Consumer Discretionary BDK  
BMC Software Information Technology BMC  
Boeing Industrials BA  
Boston Properties Financials BXP  
Boston Scientific Health Care BSX  
Bristol Myers Squibb Health Care BMY  
Broadcom Information Technology   BRCM
Brown-Forman Consumer Staples BF.B  
Brunswick Consumer Discretionary BC  
Burlington Northern Santa Fe Industrials BNI  
C.H. Robinson Worldwide Industrials   CHRW
C.R. Bard Health Care BCR  
CA Information Technology CA  
Campbell Soup Consumer Staples CPB  
Capital One Financial Financials COF  
Cardinal Health Health Care CAH  
Carnival Consumer Discretionary CCL  
Caterpillar Industrials CAT  
CB Richard Ellis Group Financials CBG  
CBS Consumer Discretionary CBS  
Celgene Health Care   CELG
CenterPoint Energy Utilities CNP  
Centex Consumer Discretionary CTX  
CenturyTel Telecommunications Services CTL  
Charles Schwab Financials   SCHW
Chesapeake Energy Energy CHK  
Chevron Energy CVX  
Chubb Financials CB  
Ciena Information Technology   CIEN
CIGNA Health Care CI  
Cincinnati Financial Financials   CINF
Cintas Industrials   CTAS
Circuit City Stores Consumer Discretionary CC  
Cisco Systems Information Technology   CSCO
CIT Group Financials CIT  
Citigroup Financials C  
Citizens Communications Telecommunications Services CZN  
Citrix Systems Information Technology   CTXS
Clear Channel Communications Consumer Discretionary CCU  
Clorox Consumer Staples CLX  
CME Group Financials CME  
CMS Energy Utilities CMS  
Coach Consumer Discretionary COH  
Coca-Cola Consumer Staples KO  
Coca-Cola Enterprises Consumer Staples CCE  
Cognizant Technology Solutions Information Technology   CTSH
Colgate-Palmolive Consumer Staples CL  
Comcast Consumer Discretionary   CMCSA
Comerica Financials CMA  
Commerce Bancorp Financials CBH  
Computer Sciences Information Technology CSC  
Compuware Information Technology CPWR  
ConAgra Foods Consumer Staples CAG  
ConocoPhillips Energy COP  
CONSOL Energy Energy CNX  
Consolidated Edison Utilities ED  
Constellation Brands Consumer Staples STZ  
Constellation Energy Group Utilities STZ  
Convergys Information Technology CVG  
Cooper Industries Industrials CBE  
Corning Information Technology GLW  
Costco Consumer Staples   COST
Countrywide Financial Financials CFC  
Coventry Health Care Health Care CVH  
Covidien Health Care COV  
CSX Industrials CSX  
Cummins Industrials CMI  
CVS Caremark Consumer Staples CVS  
D.R. Horton Consumer Discretionary DHI  
Danaher Industrials DHR  
Darden Restaurants Consumer Discretionary DRI  
Dean Foods Consumer Staples DF  
Deere & Company Industrials DE  
Dell Information Technology   DELL
Developers Diversified Realty Financials DDR  
Devon Energy Energy DVN  
Dillard Consumer Discretionary DDS  
DIRECTV Group Consumer Discretionary DTV  
Discover Financial Services Financials DFS  
Dominion Resources Utilities D  
Dover Industrials DOV  
Dow Chemical Materials DOW  
Dow Jones & Company Consumer Discretionary DJ  
DTE Energy Utilities DTE  
Duke Energy Utilities DUK  
DuPont Materials DD  
Dynegy Utilities DYN  
E TRADE Financial Financials   ETFC
E.W. Scripps Consumer Discretionary SSP  
Eastman Chemical Materials EMN  
Eastman Kodak Consumer Discretionary EK  
Eaton Industrials ETN  
eBay Information Technology   EBAY
Ecolab Materials ECL  
Edison International Utilities EIX  
El Paso Energy EP  
Electronic Arts Information Technology ERTS  
Electronic Data Systems Information Technology EDS  
Eli Lilly & Co. Health Care LLY  
Embarq Telecommunications Services EQ  
EMC Information Technology EMC  
Emerson Electric Industrials EMR  
ENSCO International Energy ESV  
Entergy Utilities ETR  
EOG Resources Energy EOG  
Equifax Industrials EFX  
Equity Residential Financials EQR  
Estee Lauder Consumer Staples EL  
Exelon Utilities EXC  
Expedia Consumer Discretionary   EXPE
Expeditors International Industrials   EXPD
Express Scripts Health Care   ESRX
Exxon Mobil Energy XOM  
Family Dollar Stores Consumer Discretionary FDO  
Fannie Mae Financials FNM  
Federated Investors Financials FII  
FedEx Industrials FDX  
Fidelity National Information Services Information Technology FIS  
Fifth Third Bancorp Financials   FITB
First Horizon National Financials FHN  
FirstEnergy Utilities FE  
FIserv Information Technology   FISV
Fluor Industrials FLR  
Ford Motor Consumer Discretionary F  
Forest Laboratories Health Care FRX  
Fortune Brands Consumer Discretionary FO  
FPL Group Utilities FPL  
Franklin Resources Financials BEN  
Freddie Mac Financials FRE  
Freeport-McMoRan Copper & Gold Materials FCX  
Gannett Consumer Discretionary GCI  
Gap Consumer Discretionary GAP  
General Dynamics Industrials GD  
General Electric Industrials GE  
General Mills Consumer Staples GIS  
General Motors Consumer Discretionary GM  
Genl Growth Properties Financials GGP  
Genuine Parts Consumer Discretionary GPC  
Genworth Financial Financials GNW  
Genzyme Health Care   GENZ
Gilead Sciences Health Care   GILD
Goldman Sachs Group Financials GS  
Goodrich Corporation Industrials GR  
Goodyear Tire & Rubber Consumer Discretionary GT  
Google Information Technology   GOOG
H&R Block Consumer Discretionary HRB  
H.J. Heinz Consumer Staples HNZ  
Halliburton Energy HAL  
Harley-Davidson Consumer Discretionary HOG  
Harman International Industries Consumer Discretionary HAR  
Harrah's Entertainment Consumer Discretionary HET  
Hartford Financial Services Financials HIG  
Ha*****ro Consumer Discretionary HAS  
Hercules Materials HPC  
Hershey Consumer Staples HSY  
Hess Energy HES  
Hewlett-Packard Information Technology HPQ  
Home Depot Consumer Discretionary HD  
Honeywell Industrials HON  
Hospira Health Care HSP  
Host Hotels & Resorts Financials HST  
Hudson City Bancorp Financials HCBK  
Humana Health Care HUM  
Huntington Bancshares Financials HBAN  
IAC InterActiveCorp Consumer Discretionary IACI  
IBM Information Technology IBM  
Illinois Tool Works Industrials ITW  
IMS Health Health Care RX  
Ingersoll-Rand Industrials IR  
Integrys Energy Group Utilities TEG  
Intel Information Technology   INTC
IntercontinentalExchange Financials ICE  
International Flavors & Fragrances Materials IFF  
International Game Technology Consumer Discretionary IGT  
International Paper Materials IP  
Interpublic Group Consumer Discretionary IPG  
Intuit Information Technology   INTU
ITT Corporation Industrials ITT  
J.C. Penney Consumer Discretionary JCP  
Jabil Circuit Information Technology JBL  
Jacobs Engineering Group Industrials JEC  
Janus Capital Group Financials JNS  
JDS Uniphase Information Technology JDSU  
Johnson & Johnson Health Care JNJ  
Johnson Controls Consumer Discretionary JCI  
Jones Apparel Group Consumer Discretionary JNY  
JPMorgan Chase Financials JPM  
Juniper Networks Information Technology JNPR  
KB Home Consumer Discretionary KBH  
Kellogg Consumer Staples K  
KeyCorp Financials KEY  
Kimberly-Clark Consumer Staples KMB  
Kimco Realty Financials KIM  
King Pharmaceuticals Health Care KG  
KLA-Tencor Information Technology   KLAC
Kohl's Consumer Discretionary KSS  
Kraft Foods Consumer Staples KFT  
Kroger Consumer Staples KR  
L-3 Communications Holdings Industrials LLL  
Laboratory Corp. of America Holdings Health Care LH  
Legg Mason Financials LM  
Leggett & Platt Consumer Discretionary LEG  
Lehman Brothers Holdings Financials LEH  
Lennar Consumer Discretionary LEN  
Leucadia National Financials LUK  
Lexmark International Information Technology LXK  
Limited Brands Consumer Discretionary LTD  
Lincoln National Financials LNC  
Linear Technology Information Technology   LLTC
Liz Claiborne Consumer Discretionary LIZ  
Lockheed Martin Industrials LMT  
Loews Financials LTR  
Lowe's Companies Consumer Discretionary LOW  
LSI Information Technology LSI  
M&T Bank Financials MTB  
Macy's Consumer Discretionary M  
Manitowoc Industrials MTW  
Marathon Oil Energy MRO  
Marriott International Consumer Discretionary MAR  
Marsh & McLennan Financials MMC  
Marshall & Ilsley Financials MI  
Masco Industrials MAS  
Mattel Consumer Discretionary MAT  
MBIA Financials MBI  
McCormick & Company Consumer Staples MKC  
McDonald's Consumer Discretionary MCD  
McGraw-Hill Consumer Discretionary MHP  
McKesson Health Care MCK  
MeadWestvaco Materials MWV  
Medco Health Solutions Health Care MHS  
Medtronic Health Care MDT  
MEMC Electronic Materials Information Technology WFR  
Merck Health Care MRK  
Meredith Consumer Discretionary MDP  
Merrill Lynch Financials MER  
MetLife Financials MET  
MGIC Investment Financials MTG  
Microchip Technology Information Technology MCHP  
Micron Technology Information Technology MU  
Microsoft Information Technology   MSFT
Millipore Health Care MIL  
Molex Information Technology MOLX  
Molson Coors Brewing Consumer Staples TAP  
Monsanto Materials MON  
Monster Worldwide Industrials   MNST
Moody's Financials MCO  
Morgan Stanley Financials MS  
Motorola Information Technology MOT  
Murphy Oil Energy MUR  
Mylan Health Care MYL  
Nabors Industries Energy NBR  
National City Financials NCC  
National Oilwell Varco Energy NOV  
National Semiconductor Information Technology NSM  
Network Appliance Information Technology   NTAP
New York Times Consumer Discretionary NYT  
Newell Rubbermaid Consumer Discretionary NWL  
Newmont Mining Materials NEM  
News Corporation Consumer Discretionary NWS.A  
Nicor Utilities GAS  
NIKE Consumer Discretionary NKE  
NiSource Utilities NI  
Noble Energy NE  
Noble Energy Energy NBL  
Nordstrom Consumer Discretionary JWN  
Northern Trust Financials   NTRS
Northrop Grumman Industrials NOC  
Novell Information Technology NOVL  
Novellus Systems Information Technology   NVLS
Nucor Materials NUE  
NVIDIA Information Technology   NVDA
NYSE Euronext Financials NYX  
Occidental Petroleum Energy OXY  
Office Depot Consumer Discretionary ODP  
OfficeMax Consumer Discretionary OMX  
Omnicom Group Consumer Discretionary OMC  
Oracle Information Technology   ORCL
PACCAR Industrials   PCAR
Pactiv Materials PTV  
Pall Industrials PLL  
Parker-Hannifin Industrials PH  
Patterson Companies Health Care   PDCO
Paychex Information Technology   PAYX
Peabody Energy Energy BTU  
Pepsi Bottling Group Consumer Staples PBG  
PepsiCo Consumer Staples PEP  
PerkinElmer Health Care PKI  
Pfizer Health Care PFE  
PG&E Utilities PCG  
Pinnacle West Capital Utilities PNW  
Pitney Bowes Industrials PBI  
Plum Creek Timber Financials PCL  
PNC Financial Services Financials PNC  
Polo Ralph Lauren Consumer Discretionary RL  
PPG Industries Materials PPG  
PPL Corporation Utilities PPL  
Praxair Materials PX  
Precision Castparts Industrials PCP  
Principal Financial Group Financials PFG  
Procter & Gamble Consumer Staples PG  
Progress Energy Utilities PGN  
Progressive Financials PGR  
ProLogis Financials PLD  
Prudential Financial Financials PRU  
Public Service Enterprise Group Utilities PEG  
Public Storage Financials PSA  
Pulte Homes Consumer Discretionary PHM  
QLogic Information Technology   QLGC
QUALCOMM Information Technology   QCOM
Quest Diagnostics Health Care DGX  
Questar Utilities STR  
Qwest Communications Telecommunications Services Q  
R.R. Donnelley & Sons Industrials RRD  
RadioShack Consumer Discretionary RSH  
Raytheon Industrials RTN  
Regions Financial Financials RF  
Reynolds American Consumer Staples RAI  
Robert Half International Industrials RHI  
Rockwell Automation Industrials ROK  
Rockwell Collins Industrials COL  
Rohm and Haas Materials ROH  
Rowan Companies Energy RDC  
Ryder System Industrials R  
SAFECO Financials SAF  
Safeway Consumer Staples SWY  
SanDisk Information Technology   SNDK
Sara Lee Consumer Staples SLE  
Schering-Plough Health Care SGP  
Schlumberger Energy SLB  
Sealed Air Materials SEE  
Sears Holdings Consumer Discretionary   SHLD
Sempra Energy Utilities SRE  
Sherwin-Williams Consumer Discretionary SHW  
Sigma-Aldrich Materials   SIAL
Simon Property Group Financials SPG  
SLM Corporation Financials SLM  
Smith International Energy SII  
Snap-On Consumer Discretionary SNA  
Southern Utilities SO  
Southwest Airlines Industrials LUV  
Sovereign Bancorp Financials SOV  
Spectra Energy Energy SE  
Sprint Nextel Telecommunications Services S  
St. Jude Medical Health Care STJ  
Stanley Works Consumer Discretionary SWK  
Staples Consumer Discretionary   SPLS
Starbucks Consumer Discretionary   SBUX
Starwood Hotels & Resorts Consumer Discretionary HOT  
State Street Financials STT  
Stryker Health Care SYK  
Sun Microsystems Information Technology   JAVAD
Sunoco Energy SUN  
SunTrust Banks Financials STI  
Supervalu Consumer Staples SVU  
Symantec Information Technology   SYMC
Synovus Financial Financials SNV  
Sysco Consumer Staples SYY  
T. Rowe Price Group Financials   TROW
Target Consumer Discretionary TGT  
TECO Energy Utilities TE  
Tellabs Information Technology   TLAB
Temple-Inland Materials TIN  
Tenet Healthcare Health Care THC  
Teradata Information Technology TDC  
Teradyne Information Technology TER  
Terex Industrials TEX  
Tesoro Petroleum Energy TSO  
Texas Instruments Information Technology TXN  
Textron Industrials TXT  
The Travelers Companies Financials TRV  
Thermo Fisher Scientific Health Care TMO  
Tiffany Consumer Discretionary TIF  
Time Warner Consumer Discretionary TWX  
Titanium Metals Materials TIE  
TJX Companies Consumer Discretionary TJX  
Torchmark Financials TMK  
Transocean Energy RIG  
Tribune Consumer Discretionary TRB  
Tyco Electronics Information Technology TEL  
Tyco International Industrials TYC  
Tyson Foods Consumer Staples TSN  
U.S. Bancorp Financials USB  
Union Pacific Industrials UNP  
Unisys Information Technology UIS  
United Health Group Health Care UNH  
United Parcel Service Industrials UPS  
United States Steel Materials X  
United Technologies Industrials UTX  
Unum Group Financials UNM  
UST Consumer Staples UST  
V.F. Corporation Consumer Discretionary VFC  
Valero Energy Energy VLO  
Varian Medical Systems Health Care VAR  
Verisign Information Technology   VRSN
Verizon Communications Telecommunications Services VZ  
Viacom Consumer Discretionary VIA.B  
Vornado Realty Trust Financials VNO  
Vulcan Materials Materials VMC  
W.W. Grainger Industrials GWW  
Wachovia Financials WB  
Wal-Mart Consumer Staples WMT  
Walgreen Consumer Staples WAG  
Walt Disney Consumer Discretionary DIS  
Washington Mutual Financials WM  
Waste Management Industrials WMI  
Waters Corporation Health Care WAT  
Watson Pharmaceuticals Health Care WPI  
Weatherford International Energy WFT  
WellPoint Health Care WLP  
Wells Fargo Financials WFC  
Wendy's International Consumer Discretionary WEN  
Western Union Information Technology WU  
Weyerhaeuser Materials WY  
Whirlpool Consumer Discretionary WHR  
Whole Foods Market Consumer Staples   WFMI
Williams Companies Energy WMB  
Windstream Telecommunications Services WIN  
Wm. Wrigley Jr. Consumer Staples WWY  
Wyeth Health Care WYE  
Wyndham Worldwide Consumer Discretionary WYN  
Xcel Energy Utilities XEL  
Xerox Information Technology XRX  
Xilinx Information Technology XLNX  
XL Capital Financials XL  
XTO Energy Energy XTO  
Yahoo Information Technology   YHOO
Yum! Brands Consumer Discretionary YUM  
Zimmer Holdings Health Care ZMH  
Zions Bancorp Financials   ZION
请您先登陆,再发跟帖!