Spreadsheet: 164111d1340651915-help-combine-if-and-vlookup-forumlas-or-another-way-of-getting-the-solution-test-formulas_response
Sheet: Duplicates

SIC Code |  | Industry Description (OLD SIC) | [NAME] | Industry Descriptions NAICS | CB Ratio | [NAME] | CR # Days | Normal Risk % of Annual Sales
5714 |  | Drapery | 442291 | Window Treatment Stores | 0.01 | 0.01 | 0.01 | 0.01
5719 |  | Home Furnishings | 442291 | Window Treatment Stores | 0.01 | 0.01 | 0.01 | 0.02
7699 |  | Misc. Repair | 442299 | All Other Home Furnishings Stores | 0.01 | 0.01 | 0.01 | 0.03
5719 |  | Home Furnishings | 442299 | All Other Home Furnishings Stores | 0.01 | 0.01 | 0.01 | 0.04
5999 |  | [NAME]. Retail | 443112 | Radio, Television, and Other Electronics Stores | 0.01 | 0.01 | 0.01 | 0.05
7622 |  | TV/Radio Repair | 443112 | Radio, Television, and Other Electronics Stores | 0.01 | 0.01 | 0.01 | 0.06
5732 |  | Electronics | 443112 | Radio, Television, and Other Electronics Stores | 0.01 | 0.01 | 0.01 | 0.07
5251 |  | Hardware | 444130 | Hardware Stores | 0.01 | 0.01 | 0.01 | 0.08
7699 |  | Misc. Repair | 444130 | Hardware Stores | 0.01 | 0.01 | 0.01 | 0.09
5231 |  | Decorator | 444190 | Other Building Material Dealers | 0.01 | 0.01 | 0.01 | 0.1
5211 |  | Building Materials | 444190 | Other Building Material Dealers | 0.01 | 0.01 | 0.01 | 0.11
5261 |  | Nursery | 444210 | Outdoor Power Equipment Stores | 0.01 | 0.01 | 0.01 | 0.12
7699 |  | Misc. Repair | 444210 | Outdoor Power Equipment Stores | 0.01 | 0.01 | 0.01 | 0.13
5411 |  | [NAME] | 447110 | Gasoline Stations with Convenience Stores | 0.01 | 0.01 | 0.01 | 0.14
5541 |  | Gas Station | 447110 | Gasoline Stations with Convenience Stores | 0.01 | 0.01 | 0.01 | 0.15
5611 |  | Men's Wear | 448150 | Clothing Accessories Stores | 0.01 | 0.01 | 0.01 | 0.16
5631 |  | Women's Accessory | 448150 | Clothing Accessories Stores | 0.01 | 0.01 | 0.01 | 0.17
5699 |  | [NAME]. Apparel | 448150 | Clothing Accessories Stores | 0.01 | 0.01 | 0.01 | 0.18
5621 |  | Women's Wear | 448190 | Other Clothing Stores | 0.01 | 0.01 | 0.01 | 0.19
5631 |  | Women's Accessory | 448190 | Other Clothing Stores | 0.01 | 0.01 | 0.01 | 0.2
5699 |  | [NAME]. Apparel | 448190 | Other Clothing Stores | 0.01 | 0.01 | 0.01 | 0.21
5941 |  | Sporting Goods | 451110 | Sporting Goods Stores | 0.01 | 0.01 | 0.01 | 0.22
7699 |  | Misc. Repair | 451110 | Sporting Goods Stores | 0.01 | 0.01 | 0.01 | 0.23
5949 |  | Sewing | 451130 | Sewing, Needlework, and Piece Goods Stores | 0.01 | 0.01 | 0.01 | 0.24
5714 |  | Drapery | 451130 | Sewing, Needlework, and Piece Goods Stores | 0.01 | 0.01 | 0.01 | 0.25
5331 |  | [NAME] | 452111 | Department Stores (except Discount Department Stores) | 0.01 | 0.01 | 0.01 | 0.26
5311 |  | Department Stores | 452111 | Department Stores (except Discount Department Stores) | 0.01 | 0.01 | 0.01 | 0.27
5331 |  | [NAME] | 452112 | Discount Department Stores | 0.01 | 0.01 | 0.01 | 0.28
5311 |  | Department Stores | 452112 | Discount Department Stores | 0.01 | 0.01 | 0.01 | 0.29
5399 |  | General Store | 452910 | [NAME] and Supercenters | 0.01 | 0.01 | 0.01 | 0.3
5411 |  | [NAME] | 452910 | [NAME] and Supercenters | 0.01 | 0.01 | 0.01 | 0.31
5399 |  | General Store | 452990 | All Other General Merchandise Stores | 0.01 | 0.01 | 0.01 | 0.32
5531 |  | Auto Supply | 452990 | All Other General Merchandise Stores | 0.01 | 0.01 | 0.01 | 0.33
7299 |  | Personal Service | 561310 | Employment Placement Agencies | 0.01 | 0.01 | 0.01 | 0.34
7922 |  | Theater | 561310 | Employment Placement Agencies | 0.01 | 0.01 | 0.01 | 0.35
7999 |  | Amusement | 561599 | All Other Travel Arrangement and Reservation Services | 0.01 | 0.01 | 0.01 | 0.36
7922 |  | Theater | 561599 | All Other Travel Arrangement and Reservation Services | 0.01 | 0.01 | 0.01 | 0.37
7911 |  | [NAME] | 611610 | Fine Arts Schools | 0.01 | 0.01 | 0.01 | 0.38
8299 |  | [NAME]. Education | 611610 | Fine Arts Schools | 0.01 | 0.01 | 0.01 | 0.39
7999 |  | Amusement | 611620 | Sports and Recreation Instruction | 0.01 | 0.01 | 0.01 | 0.4
8299 |  | [NAME]. Education | 611620 | Sports and Recreation Instruction | 0.01 | 0.01 | 0.01 | 0.41
7999 |  | Amusement | 611699 | All Other Miscellaneous Schools and Instruction | 0.01 | 0.01 | 0.01 | 0.42
8299 |  | [NAME]. Education | 611699 | All Other Miscellaneous Schools and Instruction | 0.01 | 0.01 | 0.01 | 0.43
5812 |  | Restaurant | 711110 | Theater Companies and Dinner Theaters | 0.01 | 0.01 | 0.01 | 0.44
7922 |  | Theater | 711110 | Theater Companies and Dinner Theaters | 0.01 | 0.01 | 0.01 | 0.45
7999 |  | Amusement | 711310 | Promoters of Performing Arts, Sports, and Similar Events with Facilities | 0.01 | 0.01 | 0.01 | 0.46
7922 |  | Theater | 711310 | Promoters of Performing Arts, Sports, and Similar Events with Facilities | 0.01 | 0.01 | 0.01 | 0.47
7999 |  | Amusement | 711320 | Promoters of Performing Arts, Sports, and Similar Events without Facilities | 0.01 | 0.01 | 0.01 | 0.48
7922 |  | Theater | 711320 | Promoters of Performing Arts, Sports, and Similar Events without Facilities | 0.01 | 0.01 | 0.01 | 0.49
7699 |  | Misc. Repair | 711510 | Independent Artists, [NAME], and Performers | 0.01 | 0.01 | 0.01 | 0.5
7922 |  | Theater | 711510 | Independent Artists, [NAME], and Performers | 0.01 | 0.01 | 0.01 | 0.51
7999 |  | Amusement | 713940 | Fitness and Recreational Sports Centers | 0.01 | 0.01 | 0.01 | 0.52
7997 |  | Club/Membership | 713940 | Fitness and Recreational Sports Centers | 0.01 | 0.01 | 0.01 | 0.53
7999 |  | Amusement | 713990 | All Other Amusement and Recreation Industries | 0.01 | 0.01 | 0.01 | 0.54
7911 |  | [NAME] | 713990 | All Other Amusement and Recreation Industries | 0.01 | 0.01 | 0.01 | 0.55
7997 |  | Club/Membership | 713990 | All Other Amusement and Recreation Industries | 0.01 | 0.01 | 0.01 | 0.56
7622 |  | TV/Radio Repair | 811211 | Consumer Electronics Repair and Maintenance | 0.01 | 0.01 | 0.01 | 0.57
7699 |  | Misc. Repair | 811211 | Consumer Electronics Repair and Maintenance | 0.01 | 0.01 | 0.01 | 0.58
7299 |  | Personal Service | 812990 | All Other Personal Services | 0.01 | 0.01 | 0.01 | 0.59
7999 |  | Amusement | 812990 | All Other Personal Services | 0.01 | 0.01 | 0.01 | 0.6
4899 |  | Communications | 812990 | All Other Personal Services | 0.01 | 0.01 | 0.01 | 0.61