Spreadsheet: 171136d1343647100-urgent-vlookup-array-or-index-help-ranking-logic
Sheet: Query2

RM_Code | MCC_Code | CountOfMCC_Code | SellerName | MCC Description
R05 | 5621 | 89 | [NAME] | Women's Ready to Wear Stores
R05 | 5655 | 282 | [NAME] | [NAME], Riding Apparel Stores
R05 | 5712 | 283 | [NAME] | Equipment, Furniture, and Home Furnishings Stores (except Appliances)
R05 | 5968 | 32 | [NAME] | Direct Marketing - Continuity/Subscription Merchants (Visa and MasterCard only)
R05 | 5999 | 54 | [NAME] | Miscellaneous and Specialty Retail Stores
R05 | 6010 | 1052 | [NAME] | Financial Institutions - Manual Cash Disbursements (Deposit Account, Travelers Cheques, Foreign Currency, Money Orders, Precious Metals, Savings Bonds)
R05 | 6012 | 131 | [NAME] | Financial Institutions - Merchandise and Services
R05 | 6211 | 17 | [NAME] | Securities - Brokers/Dealers
R05 | 6300 | 91 | [NAME] | Insurance Sales, Underwriting, and Premiums
R05 | 7399 | 14 | [NAME] | Business Services not elsewhere classified
R05 | 7941 | 12 | [NAME] | Commercial Sports, Professional Sports Clubs, Athletic Fields, Sports Promoters
R05 | 7997 | 73 | [NAME] | Membership Clubs (Sports, Recreation, Athletic), [NAME], Private Golf Courses
R05 | 8675 | 75 | [NAME] | Automobile Associations
R05 | 8999 | 16 | [NAME] | Professional Services not elsewhere classified
R10 | 0742 | 170 | SARA CHAMBERS | Veterinary Services
R10 | 4722 | 222 | SARA CHAMBERS | Travel Agencies and Tour Operators
R10 | 5065 | 26 | SARA CHAMBERS | Electrical Parts and Equipment
R10 | 5192 | 13 | SARA CHAMBERS | Books, Periodicals, and Newspapers
R10 | 5211 | 18 | SARA CHAMBERS | Lumber and Building Materials Stores
R10 | 5271 | 19 | SARA CHAMBERS | Mobile Home Dealers
R10 | 5411 | 42 | SARA CHAMBERS | Grocery Stores, Supermarkets
R10 | 5499 | 15 | SARA CHAMBERS | Miscellaneous Food Stores - Specialty, Markets, Convenience and Vending Machines
R10 | 5511 | 45 | SARA CHAMBERS | Automobile and Truck Dealers - Sales, Service, Repairs, Parts, and Leasing
R10 | 5611 | 31 | SARA CHAMBERS | Men's and Boys' Clothing and Furnishings Stores
R10 | 5651 | 22 | SARA CHAMBERS | Family Clothing Stores
R10 | 5691 | 58 | SARA CHAMBERS | Men's and Women's Clothing Stores
R10 | 5712 | 20 | SARA CHAMBERS | Equipment, Furniture, and Home Furnishings Stores (except Appliances)
R10 | 5714 | 37 | SARA CHAMBERS | Drapery, Upholstery, and Window Coverings Stores
R10 | 5732 | 53 | SARA CHAMBERS | Electronics Sales
R10 | 5812 | 120 | SARA CHAMBERS | Eating Places, Restaurants
R10 | 5940 | 52 | SARA CHAMBERS | Bicycle Shops - Sales and Service
R10 | 5941 | 11 | SARA CHAMBERS | Sporting Goods Stores
R10 | 5944 | 35 | SARA CHAMBERS | Jewelry Stores - Watches, Clocks, Jewelry, and Silverware Stores
R10 | 5968 | 13 | SARA CHAMBERS | Direct Marketing - Continuity/Subscription Merchants (Visa and MasterCard only)
R10 | 5999 | 41 | SARA CHAMBERS | Miscellaneous and Specialty Retail Stores
R10 | 6300 | 92 | SARA CHAMBERS | Insurance Sales, Underwriting, and Premiums
R10 | 7011 | 156 | SARA CHAMBERS | Lodging - Hotels, Motels, [NAME] not elsewhere classified
R10 | 7299 | 43 | SARA CHAMBERS | Other Services not elsewhere classified
R10 | 8021 | 111 | SARA CHAMBERS | Dentists, Orthodontists
R10 | 8071 | 19 | SARA CHAMBERS | Medical and Dental Laboratories
R10 | 8999 | 82 | SARA CHAMBERS | Professional Services not elsewhere classified
R12 | 0742 | 130 | ZOE MITCHELL | Veterinary Services
R12 | 1520 | 51 | ZOE MITCHELL | General [NAME] and Commercial
R12 | 1799 | 29 | ZOE MITCHELL | Contractors, Special Trade not elsewhere classified
R12 | 3716 | 32 | ZOE MITCHELL | Carlton Hotels (Visa and MasterCard only)
R12 | 4722 | 298 | ZOE MITCHELL | Travel Agencies and Tour Operators
R12 | 5045 | 13 | ZOE MITCHELL | Computers, Computer Peripheral Equipment, Software
R12 | 5065 | 26 | ZOE MITCHELL | Electrical Parts and Equipment
R12 | 5072 | 22 | ZOE MITCHELL | Hardware Equipment and Supplies
R12 | 5074 | 45 | ZOE MITCHELL | Plumbing and Heating Equipment
R12 | 5211 | 193 | ZOE MITCHELL | Lumber and Building Materials Stores
R12 | 5251 | 16 | ZOE MITCHELL | Hardware Stores
R12 | 5261 | 182 | ZOE MITCHELL | Lawn & Garden Supply Stores
R12 | 5411 | 17 | ZOE MITCHELL | Grocery Stores, Supermarkets
R12 | 5499 | 21 | ZOE MITCHELL | Miscellaneous Food Stores - Specialty, Markets, Convenience and Vending Machines
R12 | 5511 | 201 | ZOE MITCHELL | Automobile and Truck Dealers - Sales, Service, Repairs, Parts, and Leasing
R12 | 5521 | 11 | ZOE MITCHELL | Automobile and Truck Dealers (Used Only) - Sales
R12 | 5532 | 24 | ZOE MITCHELL | Automotive Tire Stores
R12 | 5533 | 26 | ZOE MITCHELL | Automotive Parts, Accessories Stores
R12 | 5571 | 12 | ZOE MITCHELL | Motorcycle Shops and Dealers
R12 | 5599 | 28 | ZOE MITCHELL | [NAME], Aircraft, and Farm Equipment Dealers - not elsewhere classified
R12 | 5611 | 17 | ZOE MITCHELL | Men's and Boys' Clothing and Furnishings Stores
R12 | 5621 | 58 | ZOE MITCHELL | Women's Ready to Wear Stores
R12 | 5691 | 80 | ZOE MITCHELL | Men's and Women's Clothing Stores
R12 | 5712 | 46 | ZOE MITCHELL | Equipment, Furniture, and Home Furnishings Stores (except Appliances)
R12 | 5713 | 19 | ZOE MITCHELL | Floor Covering Stores
R12 | 5714 | 16 | ZOE MITCHELL | Drapery, Upholstery, and Window Coverings Stores
R12 | 5719 | 13 | ZOE MITCHELL | Miscellaneous House Furnishing Specialty Shops
R12 | 5722 | 52 | ZOE MITCHELL | Household Appliance Stores
R12 | 5732 | 43 | ZOE MITCHELL | Electronics Sales
R12 | 5733 | 11 | ZOE MITCHELL | Music Stores - Musical Instruments, Pianos, Sheet Music
R12 | 5812 | 583 | ZOE MITCHELL | Eating Places, Restaurants
R12 | 5813 | 15 | ZOE MITCHELL | Drinking Places (Alcoholic Beverages) - Bars, Taverns, Nightclubs, Cocktail Lounges, Discotheques
R12 | 5933 | 187 | ZOE MITCHELL | Pawn Shops
R12 | 5941 | 56 | ZOE MITCHELL | Sporting Goods Stores
R12 | 5942 | 44 | ZOE MITCHELL | Book Stores
R12 | 5944 | 51 | ZOE MITCHELL | Jewelry Stores - Watches, Clocks, Jewelry, and Silverware Stores
R12 | 5946 | 22 | ZOE MITCHELL | Camera and Photographic Supply Stores
R12 | 5947 | 33 | ZOE MITCHELL | [NAME], [NAME], [NAME], and Souvenir Shops
R12 | 5948 | 75 | ZOE MITCHELL | Luggage and Leather Goods Stores
R12 | 5949 | 18 | ZOE MITCHELL | Sewing, Needlework, Fabric, and Piece Goods Stores
R12 | 5964 | 19 | ZOE MITCHELL | Direct Marketing - Catalog Merchants (Visa and MasterCard only)
R12 | 5970 | 23 | ZOE MITCHELL | Artist Supply Stores, Craft Shops
R12 | 5971 | 21 | ZOE MITCHELL | Art Dealers and Galleries
R12 | 5977 | 21 | ZOE MITCHELL | Cosmetic Stores
R12 | 5983 | 13 | ZOE MITCHELL | Fuel Dealers - Coal, Fuel Oil, Liquefied Petroleum, Wood
R12 | 5995 | 37 | ZOE MITCHELL | Pet Shops - Pet Food and Supply Stores
R12 | 5999 | 128 | ZOE MITCHELL | Miscellaneous and Specialty Retail Stores
R12 | 6012 | 22 | ZOE MITCHELL | Financial Institutions - Merchandise and Services
R12 | 6300 | 28 | ZOE MITCHELL | Insurance Sales, Underwriting, and Premiums
R12 | 7011 | 223 | ZOE MITCHELL | Lodging - Hotels, Motels, [NAME] not elsewhere classified
R12 | 7033 | 13 | ZOE MITCHELL | Campgrounds and [NAME]
R12 | 7230 | 44 | ZOE MITCHELL | [NAME] and Barber Shops
R12 | 7299 | 40 | ZOE MITCHELL | Other Services not elsewhere classified
R12 | 7399 | 107 | ZOE MITCHELL | Business Services not elsewhere classified
R12 | 7531 | 12 | ZOE MITCHELL | Automotive Body Repair Shops
R12 | 7538 | 31 | ZOE MITCHELL | Automotive Service Shops
R12 | 7629 | 12 | ZOE MITCHELL | Electrical and Small Appliance Repair Shops
R12 | 7922 | 58 | ZOE MITCHELL | Theatrical Producers (Except Motion Pictures), Ticket Agencies
R12 | 7941 | 34 | ZOE MITCHELL | Commercial Sports, Professional Sports Clubs, Athletic Fields, Sports Promoters
R12 | 7991 | 33 | ZOE MITCHELL | Tourist Attractions and [NAME]
R12 | 7997 | 28 | ZOE MITCHELL | Membership Clubs (Sports, Recreation, Athletic), [NAME], Private Golf Courses
R12 | 8062 | 61 | ZOE MITCHELL | Hospitals
R12 | 8220 | 39 | ZOE MITCHELL | Colleges, Universities, Professional Schools, and Junior Colleges
R12 | 8351 | 22 | ZOE MITCHELL | Child Care Services
R12 | 8699 | 13 | ZOE MITCHELL | Membership Organizations not elsewhere classified
R12 | 8911 | 16 | ZOE MITCHELL | Engineering, Architectural, and Surveying Services
R12 | 8999 | 51 | ZOE MITCHELL | Professional Services not elsewhere classified
R13 | 0742 | 53 | SYBILLE MUIR | Veterinary Services
R13 | 4111 | 18 | SYBILLE MUIR | Transportation - Suburban and Local Commuter Passenger, including Ferries
R13 | 4121 | 20 | SYBILLE MUIR | Taxicabs/ Limousines
R13 | 4131 | 127 | SYBILLE MUIR | Bus Lines
R13 | 4214 | 29 | SYBILLE MUIR | Motor Freight Carriers, Trucking - Local/ Long Distance, Moving and Storage Companies, Local Delivery
R13 | 4722 | 134 | SYBILLE MUIR | Travel Agencies and Tour Operators
R13 | 4816 | 13 | SYBILLE MUIR | Computer Network/Information Services
R13 | 5211 | 15 | SYBILLE MUIR | Lumber and Building Materials Stores
R13 | 5251 | 11 | SYBILLE MUIR | Hardware Stores
R13 | 5511 | 109 | SYBILLE MUIR | Automobile and Truck Dealers - Sales, Service, Repairs, Parts, and Leasing
R13 | 5521 | 17 | SYBILLE MUIR | Automobile and Truck Dealers (Used Only) - Sales
R13 | 5533 | 29 | SYBILLE MUIR | Automotive Parts, Accessories Stores
R13 | 5599 | 34 | SYBILLE MUIR | [NAME], Aircraft, and Farm Equipment Dealers - not elsewhere classified
R13 | 5621 | 14 | SYBILLE MUIR | Women's Ready to Wear Stores
R13 | 5699 | 24 | SYBILLE MUIR | [NAME] and Accessory Stores
R13 | 5712 | 32 | SYBILLE MUIR | Equipment, Furniture, and Home Furnishings Stores (except Appliances)
R13 | 5719 | 14 | SYBILLE MUIR | Miscellaneous House Furnishing Specialty Shops
R13 | 5812 | 147 | SYBILLE MUIR | Eating Places, Restaurants
R13 | 5813 | 12 | SYBILLE MUIR | Drinking Places (Alcoholic Beverages) - Bars, Taverns, Nightclubs, Cocktail Lounges, Discotheques
R13 | 5943 | 22 | SYBILLE MUIR | Stationery, Office and School Supply Stores
R13 | 5944 | 43 | SYBILLE MUIR | Jewelry Stores - Watches, Clocks, Jewelry, and Silverware Stores
R13 | 5947 | 83 | SYBILLE MUIR | [NAME], [NAME], [NAME], and Souvenir Shops
R13 | 5968 | 18 | SYBILLE MUIR | Direct Marketing - Continuity/Subscription Merchants (Visa and MasterCard only)
R13 | 5999 | 61 | SYBILLE MUIR | Miscellaneous and Specialty Retail Stores
R13 | 6051 | 576 | SYBILLE MUIR | Non-Financial Institutions - Foreign Currency, Money Orders (not wire transfer), [NAME]'s Cheques and Quasi-Cash (Visa and MasterCard only)
R13 | 6300 | 82 | SYBILLE MUIR | Insurance Sales, Underwriting, and Premiums
R13 | 7011 | 324 | SYBILLE MUIR | Lodging - Hotels, Motels, [NAME] not elsewhere classified
R13 | 7230 | 31 | SYBILLE MUIR | [NAME] and Barber Shops
R13 | 7299 | 11 | SYBILLE MUIR | Other Services not elsewhere classified
R13 | 7399 | 48 | SYBILLE MUIR | Business Services not elsewhere classified
R13 | 7538 | 67 | SYBILLE MUIR | Automotive Service Shops
R13 | 7922 | 21 | SYBILLE MUIR | Theatrical Producers (Except Motion Pictures), Ticket Agencies
R13 | 7997 | 58 | SYBILLE MUIR | Membership Clubs (Sports, Recreation, Athletic), [NAME], Private Golf Courses
R13 | 8220 | 44 | SYBILLE MUIR | Colleges, Universities, Professional Schools, and Junior Colleges
R14 | 0742 | 67 | [NAME] | Veterinary Services
R14 | 4722 | 121 | [NAME] | Travel Agencies and Tour Operators
R14 | 5065 | 54 | [NAME] | Electrical Parts and Equipment
R14 | 5211 | 58 | [NAME] | Lumber and Building Materials Stores
R14 | 5251 | 35 | [NAME] | Hardware Stores
R14 | 5261 | 24 | [NAME] | Lawn & Garden Supply Stores
R14 | 5441 | 18 | [NAME] | Candy, Nut Confectionery Stores
R14 | 5499 | 23 | [NAME] | Miscellaneous Food Stores - Specialty, Markets, Convenience and Vending Machines
R14 | 5511 | 42 | [NAME] | Automobile and Truck Dealers - Sales, Service, Repairs, Parts, and Leasing
R14 | 5533 | 14 | [NAME] | Automotive Parts, Accessories Stores
R14 | 5571 | 16 | [NAME] | Motorcycle Shops and Dealers
R14 | 5621 | 17 | [NAME] | Women's Ready to Wear Stores
R14 | 5655 | 13 | [NAME] | [NAME], Riding Apparel Stores
R14 | 5691 | 42 | [NAME] | Men's and Women's Clothing Stores
R14 | 5712 | 18 | [NAME] | Equipment, Furniture, and Home Furnishings Stores (except Appliances)
R14 | 5713 | 43 | [NAME] | Floor Covering Stores
R14 | 5722 | 21 | [NAME] | Household Appliance Stores
R14 | 5812 | 283 | [NAME] | Eating Places, Restaurants
R14 | 5813 | 21 | [NAME] | Drinking Places (Alcoholic Beverages) - Bars, Taverns, Nightclubs, Cocktail Lounges, Discotheques
R14 | 5814 | 41 | [NAME] | Quick Payment Service, Fast Food Restaurants
R14 | 5921 | 13 | [NAME] | Package Stores, Beer, Wine, Liquor
R14 | 5932 | 16 | [NAME] | Antique Shops - Sales, Repairs and Restoration Services
R14 | 5940 | 16 | [NAME] | Bicycle Shops - Sales and Service
R14 | 5941 | 48 | [NAME] | Sporting Goods Stores
R14 | 5942 | 31 | [NAME] | Book Stores
R14 | 5944 | 32 | [NAME] | Jewelry Stores - Watches, Clocks, Jewelry, and Silverware Stores
R14 | 5945 | 17 | [NAME] | Hobby, Toy, and Game Stores
R14 | 5968 | 14 | [NAME] | Direct Marketing - Continuity/Subscription Merchants (Visa and MasterCard only)
R14 | 5971 | 14 | [NAME] | Art Dealers and Galleries
R14 | 5992 | 15 | [NAME] | Florists
R14 | 5995 | 27 | [NAME] | Pet Shops - Pet Food and Supply Stores
R14 | 5999 | 69 | [NAME] | Miscellaneous and Specialty Retail Stores
R14 | 6300 | 38 | [NAME] | Insurance Sales, Underwriting, and Premiums
R14 | 7011 | 187 | [NAME] | Lodging - Hotels, Motels, [NAME] not elsewhere classified
R14 | 7230 | 61 | [NAME] | [NAME] and Barber Shops
R14 | 7298 | 39 | [NAME] | Health and [NAME]
R14 | 7299 | 41 | [NAME] | Other Services not elsewhere classified
R14 | 7399 | 60 | [NAME] | Business Services not elsewhere classified
R14 | 7512 | 15 | [NAME] | Automobile Rental Agency
R14 | 7538 | 59 | [NAME] | Automotive Service Shops
R14 | 7623 | 29 | [NAME] | Air Conditioning and Refrigeration Repair Shops
R14 | 7922 | 12 | [NAME] | Theatrical Producers (Except Motion Pictures), Ticket Agencies
R14 | 7933 | 14 | [NAME] | Bowling Alleys
R14 | 7991 | 15 | [NAME] | Tourist Attractions and [NAME]
R14 | 7997 | 79 | [NAME] | Membership Clubs (Sports, Recreation, Athletic), [NAME], Private Golf Courses
R14 | 8062 | 16 | [NAME] | Hospitals
R14 | 8111 | 14 | [NAME] | Legal Services, Attorneys
R14 | 8220 | 32 | [NAME] | Colleges, Universities, Professional Schools, and Junior Colleges
R14 | 8911 | 33 | [NAME] | Engineering, Architectural, and Surveying Services
R14 | 8999 | 37 | [NAME] | Professional Services not elsewhere classified
R14 | 9399 | 34 | [NAME] | Government Services not elsewhere classified