Hi,
I've been struggling with an array formula that will extract duplicates out into columns.
Here's the formula:
=IF(COLUMNS($AO3:AO3)<=$AM3,INDEX($A$3:$A$1918,SMALL(IF($B$3:$B$1918=$AN3,ROW($A$3:$A$1918)-ROW($A$3)+1),COLUMNS($AO3:AO3))),"")
And here's the table:
<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>
<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>A</th><th>B</th><th>AM</th><th>AN</th><th>AO</th><th>AP</th><th>AQ</th><th>AR</th><th>AS</th><th>AT</th><th>AU</th><th>AV</th><th>AW</th><th>AX</th><th>AY</th><th>AZ</th></tr> <tr><td>Name</td><td>Address</td><td>Count</td><td>Address</td><td>Name 1</td><td>Name 2</td><td>Name 3</td><td>Name 4</td><td>Name 5</td><td>Name 6</td><td>Name 7</td><td>Name 8</td><td>Name 9</td><td>Name 10</td><td>Name 11</td><td>Name 12</td></tr> <tr><td>THE DUSSIN GROUP</td><td>0715 SW Bancroft St</td><td>2</td><td>0715 SW Bancroft St</td><td>THE DUSSIN GROUP</td><td>#NUM!</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE DUSSIN GROUP</td><td>0715 SW Bancroft St</td><td>2</td><td>1 Big Boy Dr</td><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td>BIG BOY RESTAURANTS</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td>1 Big Boy Dr</td><td>1</td><td>1 Caesars Palace Dr</td><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BIG BOY RESTAURANTS</td><td>1 Big Boy Dr</td><td>1</td><td>1 Cedar Point Dr</td><td>BIG BOY RESTAURANTS</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HARRAH'S ENTERTAINMENT INC.</td><td>1 Caesars Palace Dr</td><td>2</td><td>1 Centerpointe Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CEDAR POINT</td><td>1 Cedar Point Dr</td><td>1</td><td>1 City Centre Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>FRIENDLY FRANCHISEES CORP</td><td>1 Centerpointe Dr</td><td>2</td><td>1 Dave Thomas Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SENIOR CLASSIC LEASING LLC</td><td>1 Centerpointe Dr</td><td>1</td><td>1 Embarcadero Ctr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BOSTON PIZZA INTERNATIONAL INC. (EASTERN CANADA)</td><td>1 City Centre Dr</td><td>2</td><td>1 Glen Bell Way</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WENDY'S INTERNATIONAL INC.</td><td>1 Dave Thomas Blvd</td><td>2</td><td>1 Glenlake Pkwy NE</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WENDY'S INTERNATIONAL</td><td>1 Dave Thomas Blvd</td><td>1</td><td>1 Jericho Tpke</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ROMANO'S MACARONI GRILL</td><td>1 Embarcadero Ctr</td><td>1</td><td>1 Kroc Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TACO BELL CORP.</td><td>1 Glen Bell Way</td><td>1</td><td>1 McDonald's Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TACO BELL</td><td>1 Glen Bell Way</td><td>1</td><td>1 Mohegan Sun Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1 Glenlake Pkwy NE</td><td>1</td><td>1 N Field Ct</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RESTAURANT GROWTH BRANDS INC.</td><td>1 Glenlake Pkwy NE</td><td>1</td><td>1 Palmer Ter</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NATHAN'S FAMOUS</td><td>1 Jericho Tpke</td><td>1</td><td>1 Perimeter Park S</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S CORPORATION</td><td>1 Kroc Dr</td><td>1</td><td>1 Reservoir Office Park</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S RESTAURANTS OF CANADA LTD.</td><td>1 McDonald's Pl</td><td>1</td><td>1 Rutherford Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MOHEGAN SUN</td><td>1 Mohegan Sun Blvd</td><td>1</td><td>1 SE Convenience Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BRUNSWICK BOWLING & BILLIARDS DIVISION</td><td>1 N Field Ct</td><td>2</td><td>1 Union Sq</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>EIPCO FOODS CORP.</td><td>1 Palmer Ter</td><td>2</td><td>1 Virginia Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>GUTHRIE'S</td><td>1 Perimeter Park S</td><td>3</td><td>10 Kingsbridge Garden Cir</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HILTON HOTELS NORTHEAST REGION</td><td>1 Reservoir Office Park</td><td>2</td><td>10 Middle St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VALENTI MID-ATLANTIC MANAGEMENT INC.</td><td>1 Rutherford Rd</td><td>1</td><td>10 Riverpark Pl E</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CASEY'S CARRY-OUT PIZZA</td><td>1 SE Convenience Blvd</td><td>2</td><td>100 Centerview Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE KRYSTAL CO.</td><td>1 Union Sq</td><td>2</td><td>100 Charles Park Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KRYSTAL</td><td>1 Union Sq</td><td>2</td><td>100 E San Marcos Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NOBLE ROMAN'S PIZZA</td><td>1 Virginia Ave</td><td>1</td><td>100 E Wisconsin Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NOBLE ROMAN'S INC.</td><td>1 Virginia Ave</td><td>1</td><td>100 James Park Dr E</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRIME RESTAURANTS</td><td>10 Kingsbridge Garden Cir</td><td>2</td><td>100 Mariners Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>EAST SIDE MARIO'S RESTAURANTS INC.</td><td>10 Kingsbridge Garden Cir</td><td>1</td><td>100 N Barranca St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRIME RESTAURANTS OF CANADA INC.</td><td>10 Kingsbridge Garden Cir</td><td>1</td><td>100 N Broadway</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TREFZ CORPORATION</td><td>10 Middle St</td><td>2</td><td>100 N Crescent Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TREFZ CORPORATION</td><td>10 Middle St</td><td>2</td><td>100 Peabody Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>DYNACO FOOD CONCEPTS</td><td>10 Riverpark Pl E</td><td>2</td><td>100 Phoenix Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SNEAKY PETE'S HOT DOGS</td><td>100 Centerview Dr</td><td>1</td><td>100 SE 25th Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>S.P. FOOD SERVICES INC.</td><td>100 Centerview Dr</td><td>1</td><td>100 Universal City Plz</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNO RESTAURANT HOLDINGS CORP.</td><td>100 Charles Park Rd</td><td>1</td><td>100 Wellington St W</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNO CHICAGO GRILL</td><td>100 Charles Park Rd</td><td>1</td><td>1000 Boardwalk</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SUBMARINA CALIFORNIA SUBS</td><td>100 E San Marcos Blvd</td><td>5</td><td>1000 Darden Center Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SUBMARINA INC.</td><td>100 E San Marcos Blvd</td><td>1</td><td>1000 E 80th Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARCUS THEATRES CORPORATION</td><td>100 E Wisconsin Ave</td><td>1</td><td>1000 Market St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>STRATEGIC RESTAURANTS ACQUISITION CORP.</td><td>100 James Park Dr E</td><td>1</td><td>1000 Nicollet Mall</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MIRACLE RESTAURANT GROUP</td><td>100 Mariners Blvd</td><td>1</td><td>1000 Omega Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MIRACLE RESTAURANT GROUP</td><td>100 Mariners Blvd</td><td>1</td><td>1000 Osgood St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>JACK IN THE BOX</td><td>100 N Barranca St</td><td>1</td><td>1000 Osgood St.</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HARDEE'S FOOD SYSTEMS INC.</td><td>100 N Broadway</td><td>1</td><td>1000 Park Centre Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WOLFGANG PUCK WORLDWIDE</td><td>100 N Crescent Dr</td><td>1</td><td>1000 Universal Studios Plz</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WOLFGANG PUCK INC.</td><td>100 N Crescent Dr</td><td>2</td><td>10000 Shelbyville Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CARLISLE CORPORATION</td><td>100 Peabody Pl</td><td>2</td><td>1001 17th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CARLISLE CORPORATION</td><td>100 Peabody Pl</td><td>1</td><td>1001 Avenue Of The Americas</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BORDERS GROUP INC.</td><td>100 Phoenix Dr</td><td>1</td><td>1001 S Harimaw Ct</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BORDERS BOOKS CAFE</td><td>100 Phoenix Dr</td><td>1</td><td>1003 Jordan Ln NW</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CHICKEN EXPRESS</td><td>100 SE 25th Ave</td><td>2</td><td>1005 S Bee St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNIVERSAL STUDIOS HOLLYWOOD</td><td>100 Universal City Plz</td><td>1</td><td>1007 Okoboji Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>FAIRMONT HOTELS & RESORTS INC.</td><td>100 Wellington St W</td><td>2</td><td>10096 Shaver Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TRUMP ENTERTAINMENT RESORTS INC.</td><td>1000 Boardwalk</td><td>2</td><td>101 Chestnut Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>DARDEN RESTAURANTS INC.</td><td>1000 Darden Center Dr</td><td>2</td><td>101 E Cherokee St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>LONGHORN STEAKHOUSE</td><td>1000 Darden Center Dr</td><td>2</td><td>101 E Hopi Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OLIVE GARDEN</td><td>1000 Darden Center Dr</td><td>2</td><td>101 Exchange Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RED LOBSTER</td><td>1000 Darden Center Dr</td><td>2</td><td>101 N Ridge Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE CAPITAL GRILLE</td><td>1000 Darden Center Dr</td><td>2</td><td>101 W Renner Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WHITE LODGING SERVICES CORP.</td><td>1000 E 80th Pl</td><td>2</td><td>10100 Shellbridge Way</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OCEAN HOSPITALITIES INC.</td><td>1000 Market St</td><td>1</td><td>10114 175th St NW</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TARGET CORPORATION</td><td>1000 Nicollet Mall</td><td>1</td><td>10150 Highland Manor Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1000 Omega Dr</td><td>2</td><td>102 Commercial Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MAFUA MANAGEMENT</td><td>1000 Osgood St</td><td>1</td><td>102 S Broadway</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CAFUA MANAGEMENT</td><td>1000 Osgood St.</td><td>4</td><td>1020 Discovery Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KONING RESTAURANTS INTERNATIONAL</td><td>1000 Park Centre Blvd</td><td>1</td><td>1020 Dollywood Ln</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNIVERSAL ORLANDO RESORT</td><td>1000 Universal Studios Plz</td><td>2</td><td>1020 Milwaukee Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PATTERSON & ASSOCIATES INC.</td><td>10000 Shelbyville Rd</td><td>2</td><td>1021 Cambridge Sq</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PATTERSON & ASSOCIATES INC</td><td>10000 Shelbyville Rd</td><td>1</td><td>1021 Karl Greimel Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUIZNO'S CLASSIC SUBS</td><td>1001 17th St</td><td>2</td><td>1021 Noell Ln</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE QUIZNOS MASTER LLC</td><td>1001 17th St</td><td>1</td><td>1024 Serpentine Lane</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MUGINOHO USA INC.</td><td>1001 Avenue Of The Americas</td><td>2</td><td>1025 W Everett Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>COPELAND'S OF NEW ORLEANS INC.</td><td>1001 S Harimaw Ct</td><td>1</td><td>10260 SW Greenburg Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ALICE J. SCHLEICHER INC.</td><td>1003 Jordan Ln NW</td><td>1</td><td>10303 Jasper Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VOCELLI PIZZA</td><td>1005 S Bee St</td><td>1</td><td>10331 S Medallion Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VOCELLI PIZZA</td><td>1005 S Bee St</td><td>1</td><td>10333 Richmond Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>LAND MARK PRODUCTS INC.</td><td>1007 Okoboji Ave</td><td>2</td><td>1035 W Washington Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BELLACINO'S INCORPORATED</td><td>10096 Shaver Rd</td><td>1</td><td>10370 Hemet St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BELLACINO'S PIZZA & GRINDERS</td><td>10096 Shaver Rd</td><td>1</td><td>104 Mull St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUAKER STEAK & LUBE</td><td>101 Chestnut Ave</td><td>2</td><td>1040 Founders Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUAKER STEAK & LUBE</td><td>101 Chestnut Ave</td><td>1</td><td>10400 Fernwood Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SOUTHERN MULTIFOODS INC.</td><td>101 E Cherokee St</td><td>2</td><td>10405 Greenbriar Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SOUTHERN MULTIFOODS INC</td><td>101 E Cherokee St</td><td>2</td><td>10440 Furnace Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>Q.K. INC.</td><td>101 E Hopi Dr</td><td>2</td><td>105 E Wisconsin Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QK INC</td><td>101 E Hopi Dr</td><td>1</td><td>105 Eisenhower Pkwy</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRISZM INCOME FUND/PRISZM INC.</td><td>101 Exchange Ave</td><td>2</td><td>105 N 4th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>YUM! RESTAURANTS INTERNATIONAL (CANADA) CO.</td><td>101 Exchange Ave</td><td>1</td><td>105 S Mount Auburn Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>IN THE SAUCE BRANDS INC.</td><td>101 N Ridge Rd</td><td>1</td><td>105 Walker St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>GAMBINO'S PIZZA</td><td>101 N Ridge Rd</td><td>2</td><td>1051 Winderley Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NESTLE TOLLHOUSE CAFE BY CHIP</td><td>101 W Renner Rd</td><td>1</td><td>10550 115th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CREST FOODS INC.</td><td>101 W Renner Rd</td><td>1</td><td>10590 Cote-de-Liesse</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KEG RESTAURANTS LTD.</td><td>10100 Shellbridge Way</td><td>2</td><td>1062 Folsom St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KEG STEAKHOUSE & BAR</td><td>10100 Shellbridge Way</td><td>1</td><td>1065 Foch St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE HANSON GROUP</td><td>10114 175th St NW</td><td>2</td><td>10665 Bedford Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>10150 Highland Manor Dr</td><td>1</td><td>1071 Pemberton Hill Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE LITTLE MINT INC.</td><td>102 Commercial Ave</td><td>1</td><td>1077 Central Pkwy S</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ANDY'S BURGERS SHAKES & FRIES</td><td>102 Commercial Ave</td><td>1</td><td>108 3rd St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PAT'S FAMILY RESTAURANT INC.</td><td>102 S Broadway</td><td>1</td><td>108 N Mesquite St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BUFFETS INC</td><td>1020 Discovery Rd</td><td>2</td><td>1080 W Bethel Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OLD COUNTRY BUFFET</td><td>1020 Discovery Rd</td><td>1</td><td>10801 Mastin St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RYAN'S GRILL BUFFET BAKERY</td><td>1020 Discovery Rd</td><td>1</td><td>10864 Audelia Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BUFFETS HOLDINGS INC.</td><td>1020 Discovery Rd</td><td>1</td><td>10880 Benson St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE DOLLYWOOD COMPANY</td><td>1020 Dollywood Ln</td><td>2</td><td>1089 Little Britain Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>C H JAMES RESTAURANT HOLDINGS</td><td>1020 Milwaukee Ave</td><td>1</td><td>10897 NW 6th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CH JAMES RESTAURANT HOLDINGS LLC</td><td>1020 Milwaukee Ave</td><td>2</td><td>109 N Kentucky Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARKET PLACE INC.</td><td>1021 Cambridge Sq</td><td>4</td><td>109 New Camellia Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARKETPLACE HOLDINGS</td><td>1021 Cambridge Sq</td><td>2</td><td>109 W 17th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1021 Karl Greimel Dr</td><td>1</td><td>1090 W Georgia St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BODDIE-NOELL ENTERPRISES INC.</td><td>1021 Noell Ln</td><td>2</td><td>10930 W Potter Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BODDIE-NOELL ENTERPRISES INC</td><td>1021 Noell Ln</td><td>2</td><td>10999 Petal St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>APEX RESTAURANT MANAGEMENT INC</td><td>1024 Serpentine Lane</td><td>1</td><td>11 Princess St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCESSY INVESTMENT COMPANY</td><td>1025 W Everett Rd</td><td>1</td><td>1100 Coiner CT</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCESSY INVESTMENT CO</td><td>1025 W Everett Rd</td><td>1</td><td>11005 Dover St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>STARBUCKS NORTHWEST INTERIOR REGIONAL OFFICE</td><td>10260 SW Greenburg Rd</td><td>2</td><td>1101 E Arapaho Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td></td></tr></table>
Help!
Thanks,
Alex
I've been struggling with an array formula that will extract duplicates out into columns.
Here's the formula:
=IF(COLUMNS($AO3:AO3)<=$AM3,INDEX($A$3:$A$1918,SMALL(IF($B$3:$B$1918=$AN3,ROW($A$3:$A$1918)-ROW($A$3)+1),COLUMNS($AO3:AO3))),"")
And here's the table:
<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>
<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>A</th><th>B</th><th>AM</th><th>AN</th><th>AO</th><th>AP</th><th>AQ</th><th>AR</th><th>AS</th><th>AT</th><th>AU</th><th>AV</th><th>AW</th><th>AX</th><th>AY</th><th>AZ</th></tr> <tr><td>Name</td><td>Address</td><td>Count</td><td>Address</td><td>Name 1</td><td>Name 2</td><td>Name 3</td><td>Name 4</td><td>Name 5</td><td>Name 6</td><td>Name 7</td><td>Name 8</td><td>Name 9</td><td>Name 10</td><td>Name 11</td><td>Name 12</td></tr> <tr><td>THE DUSSIN GROUP</td><td>0715 SW Bancroft St</td><td>2</td><td>0715 SW Bancroft St</td><td>THE DUSSIN GROUP</td><td>#NUM!</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE DUSSIN GROUP</td><td>0715 SW Bancroft St</td><td>2</td><td>1 Big Boy Dr</td><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td>BIG BOY RESTAURANTS</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td>1 Big Boy Dr</td><td>1</td><td>1 Caesars Palace Dr</td><td>BIG BOY RESTAURANTS INTERNATIONAL LLC</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BIG BOY RESTAURANTS</td><td>1 Big Boy Dr</td><td>1</td><td>1 Cedar Point Dr</td><td>BIG BOY RESTAURANTS</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HARRAH'S ENTERTAINMENT INC.</td><td>1 Caesars Palace Dr</td><td>2</td><td>1 Centerpointe Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CEDAR POINT</td><td>1 Cedar Point Dr</td><td>1</td><td>1 City Centre Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>FRIENDLY FRANCHISEES CORP</td><td>1 Centerpointe Dr</td><td>2</td><td>1 Dave Thomas Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SENIOR CLASSIC LEASING LLC</td><td>1 Centerpointe Dr</td><td>1</td><td>1 Embarcadero Ctr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BOSTON PIZZA INTERNATIONAL INC. (EASTERN CANADA)</td><td>1 City Centre Dr</td><td>2</td><td>1 Glen Bell Way</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WENDY'S INTERNATIONAL INC.</td><td>1 Dave Thomas Blvd</td><td>2</td><td>1 Glenlake Pkwy NE</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WENDY'S INTERNATIONAL</td><td>1 Dave Thomas Blvd</td><td>1</td><td>1 Jericho Tpke</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ROMANO'S MACARONI GRILL</td><td>1 Embarcadero Ctr</td><td>1</td><td>1 Kroc Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TACO BELL CORP.</td><td>1 Glen Bell Way</td><td>1</td><td>1 McDonald's Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TACO BELL</td><td>1 Glen Bell Way</td><td>1</td><td>1 Mohegan Sun Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1 Glenlake Pkwy NE</td><td>1</td><td>1 N Field Ct</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RESTAURANT GROWTH BRANDS INC.</td><td>1 Glenlake Pkwy NE</td><td>1</td><td>1 Palmer Ter</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NATHAN'S FAMOUS</td><td>1 Jericho Tpke</td><td>1</td><td>1 Perimeter Park S</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S CORPORATION</td><td>1 Kroc Dr</td><td>1</td><td>1 Reservoir Office Park</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S RESTAURANTS OF CANADA LTD.</td><td>1 McDonald's Pl</td><td>1</td><td>1 Rutherford Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MOHEGAN SUN</td><td>1 Mohegan Sun Blvd</td><td>1</td><td>1 SE Convenience Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BRUNSWICK BOWLING & BILLIARDS DIVISION</td><td>1 N Field Ct</td><td>2</td><td>1 Union Sq</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>EIPCO FOODS CORP.</td><td>1 Palmer Ter</td><td>2</td><td>1 Virginia Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>GUTHRIE'S</td><td>1 Perimeter Park S</td><td>3</td><td>10 Kingsbridge Garden Cir</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HILTON HOTELS NORTHEAST REGION</td><td>1 Reservoir Office Park</td><td>2</td><td>10 Middle St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VALENTI MID-ATLANTIC MANAGEMENT INC.</td><td>1 Rutherford Rd</td><td>1</td><td>10 Riverpark Pl E</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CASEY'S CARRY-OUT PIZZA</td><td>1 SE Convenience Blvd</td><td>2</td><td>100 Centerview Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE KRYSTAL CO.</td><td>1 Union Sq</td><td>2</td><td>100 Charles Park Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KRYSTAL</td><td>1 Union Sq</td><td>2</td><td>100 E San Marcos Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NOBLE ROMAN'S PIZZA</td><td>1 Virginia Ave</td><td>1</td><td>100 E Wisconsin Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NOBLE ROMAN'S INC.</td><td>1 Virginia Ave</td><td>1</td><td>100 James Park Dr E</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRIME RESTAURANTS</td><td>10 Kingsbridge Garden Cir</td><td>2</td><td>100 Mariners Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>EAST SIDE MARIO'S RESTAURANTS INC.</td><td>10 Kingsbridge Garden Cir</td><td>1</td><td>100 N Barranca St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRIME RESTAURANTS OF CANADA INC.</td><td>10 Kingsbridge Garden Cir</td><td>1</td><td>100 N Broadway</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TREFZ CORPORATION</td><td>10 Middle St</td><td>2</td><td>100 N Crescent Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TREFZ CORPORATION</td><td>10 Middle St</td><td>2</td><td>100 Peabody Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>DYNACO FOOD CONCEPTS</td><td>10 Riverpark Pl E</td><td>2</td><td>100 Phoenix Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SNEAKY PETE'S HOT DOGS</td><td>100 Centerview Dr</td><td>1</td><td>100 SE 25th Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>S.P. FOOD SERVICES INC.</td><td>100 Centerview Dr</td><td>1</td><td>100 Universal City Plz</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNO RESTAURANT HOLDINGS CORP.</td><td>100 Charles Park Rd</td><td>1</td><td>100 Wellington St W</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNO CHICAGO GRILL</td><td>100 Charles Park Rd</td><td>1</td><td>1000 Boardwalk</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SUBMARINA CALIFORNIA SUBS</td><td>100 E San Marcos Blvd</td><td>5</td><td>1000 Darden Center Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SUBMARINA INC.</td><td>100 E San Marcos Blvd</td><td>1</td><td>1000 E 80th Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARCUS THEATRES CORPORATION</td><td>100 E Wisconsin Ave</td><td>1</td><td>1000 Market St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>STRATEGIC RESTAURANTS ACQUISITION CORP.</td><td>100 James Park Dr E</td><td>1</td><td>1000 Nicollet Mall</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MIRACLE RESTAURANT GROUP</td><td>100 Mariners Blvd</td><td>1</td><td>1000 Omega Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MIRACLE RESTAURANT GROUP</td><td>100 Mariners Blvd</td><td>1</td><td>1000 Osgood St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>JACK IN THE BOX</td><td>100 N Barranca St</td><td>1</td><td>1000 Osgood St.</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>HARDEE'S FOOD SYSTEMS INC.</td><td>100 N Broadway</td><td>1</td><td>1000 Park Centre Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WOLFGANG PUCK WORLDWIDE</td><td>100 N Crescent Dr</td><td>1</td><td>1000 Universal Studios Plz</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WOLFGANG PUCK INC.</td><td>100 N Crescent Dr</td><td>2</td><td>10000 Shelbyville Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CARLISLE CORPORATION</td><td>100 Peabody Pl</td><td>2</td><td>1001 17th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CARLISLE CORPORATION</td><td>100 Peabody Pl</td><td>1</td><td>1001 Avenue Of The Americas</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BORDERS GROUP INC.</td><td>100 Phoenix Dr</td><td>1</td><td>1001 S Harimaw Ct</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BORDERS BOOKS CAFE</td><td>100 Phoenix Dr</td><td>1</td><td>1003 Jordan Ln NW</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CHICKEN EXPRESS</td><td>100 SE 25th Ave</td><td>2</td><td>1005 S Bee St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNIVERSAL STUDIOS HOLLYWOOD</td><td>100 Universal City Plz</td><td>1</td><td>1007 Okoboji Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>FAIRMONT HOTELS & RESORTS INC.</td><td>100 Wellington St W</td><td>2</td><td>10096 Shaver Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TRUMP ENTERTAINMENT RESORTS INC.</td><td>1000 Boardwalk</td><td>2</td><td>101 Chestnut Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>DARDEN RESTAURANTS INC.</td><td>1000 Darden Center Dr</td><td>2</td><td>101 E Cherokee St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>LONGHORN STEAKHOUSE</td><td>1000 Darden Center Dr</td><td>2</td><td>101 E Hopi Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OLIVE GARDEN</td><td>1000 Darden Center Dr</td><td>2</td><td>101 Exchange Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RED LOBSTER</td><td>1000 Darden Center Dr</td><td>2</td><td>101 N Ridge Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE CAPITAL GRILLE</td><td>1000 Darden Center Dr</td><td>2</td><td>101 W Renner Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>WHITE LODGING SERVICES CORP.</td><td>1000 E 80th Pl</td><td>2</td><td>10100 Shellbridge Way</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OCEAN HOSPITALITIES INC.</td><td>1000 Market St</td><td>1</td><td>10114 175th St NW</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>TARGET CORPORATION</td><td>1000 Nicollet Mall</td><td>1</td><td>10150 Highland Manor Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1000 Omega Dr</td><td>2</td><td>102 Commercial Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MAFUA MANAGEMENT</td><td>1000 Osgood St</td><td>1</td><td>102 S Broadway</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CAFUA MANAGEMENT</td><td>1000 Osgood St.</td><td>4</td><td>1020 Discovery Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KONING RESTAURANTS INTERNATIONAL</td><td>1000 Park Centre Blvd</td><td>1</td><td>1020 Dollywood Ln</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>UNIVERSAL ORLANDO RESORT</td><td>1000 Universal Studios Plz</td><td>2</td><td>1020 Milwaukee Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PATTERSON & ASSOCIATES INC.</td><td>10000 Shelbyville Rd</td><td>2</td><td>1021 Cambridge Sq</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PATTERSON & ASSOCIATES INC</td><td>10000 Shelbyville Rd</td><td>1</td><td>1021 Karl Greimel Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUIZNO'S CLASSIC SUBS</td><td>1001 17th St</td><td>2</td><td>1021 Noell Ln</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE QUIZNOS MASTER LLC</td><td>1001 17th St</td><td>1</td><td>1024 Serpentine Lane</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MUGINOHO USA INC.</td><td>1001 Avenue Of The Americas</td><td>2</td><td>1025 W Everett Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>COPELAND'S OF NEW ORLEANS INC.</td><td>1001 S Harimaw Ct</td><td>1</td><td>10260 SW Greenburg Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ALICE J. SCHLEICHER INC.</td><td>1003 Jordan Ln NW</td><td>1</td><td>10303 Jasper Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VOCELLI PIZZA</td><td>1005 S Bee St</td><td>1</td><td>10331 S Medallion Dr</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>VOCELLI PIZZA</td><td>1005 S Bee St</td><td>1</td><td>10333 Richmond Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>LAND MARK PRODUCTS INC.</td><td>1007 Okoboji Ave</td><td>2</td><td>1035 W Washington Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BELLACINO'S INCORPORATED</td><td>10096 Shaver Rd</td><td>1</td><td>10370 Hemet St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BELLACINO'S PIZZA & GRINDERS</td><td>10096 Shaver Rd</td><td>1</td><td>104 Mull St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUAKER STEAK & LUBE</td><td>101 Chestnut Ave</td><td>2</td><td>1040 Founders Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QUAKER STEAK & LUBE</td><td>101 Chestnut Ave</td><td>1</td><td>10400 Fernwood Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SOUTHERN MULTIFOODS INC.</td><td>101 E Cherokee St</td><td>2</td><td>10405 Greenbriar Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>SOUTHERN MULTIFOODS INC</td><td>101 E Cherokee St</td><td>2</td><td>10440 Furnace Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>Q.K. INC.</td><td>101 E Hopi Dr</td><td>2</td><td>105 E Wisconsin Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>QK INC</td><td>101 E Hopi Dr</td><td>1</td><td>105 Eisenhower Pkwy</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PRISZM INCOME FUND/PRISZM INC.</td><td>101 Exchange Ave</td><td>2</td><td>105 N 4th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>YUM! RESTAURANTS INTERNATIONAL (CANADA) CO.</td><td>101 Exchange Ave</td><td>1</td><td>105 S Mount Auburn Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>IN THE SAUCE BRANDS INC.</td><td>101 N Ridge Rd</td><td>1</td><td>105 Walker St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>GAMBINO'S PIZZA</td><td>101 N Ridge Rd</td><td>2</td><td>1051 Winderley Pl</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>NESTLE TOLLHOUSE CAFE BY CHIP</td><td>101 W Renner Rd</td><td>1</td><td>10550 115th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CREST FOODS INC.</td><td>101 W Renner Rd</td><td>1</td><td>10590 Cote-de-Liesse</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KEG RESTAURANTS LTD.</td><td>10100 Shellbridge Way</td><td>2</td><td>1062 Folsom St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>KEG STEAKHOUSE & BAR</td><td>10100 Shellbridge Way</td><td>1</td><td>1065 Foch St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE HANSON GROUP</td><td>10114 175th St NW</td><td>2</td><td>10665 Bedford Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>10150 Highland Manor Dr</td><td>1</td><td>1071 Pemberton Hill Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE LITTLE MINT INC.</td><td>102 Commercial Ave</td><td>1</td><td>1077 Central Pkwy S</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>ANDY'S BURGERS SHAKES & FRIES</td><td>102 Commercial Ave</td><td>1</td><td>108 3rd St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>PAT'S FAMILY RESTAURANT INC.</td><td>102 S Broadway</td><td>1</td><td>108 N Mesquite St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BUFFETS INC</td><td>1020 Discovery Rd</td><td>2</td><td>1080 W Bethel Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>OLD COUNTRY BUFFET</td><td>1020 Discovery Rd</td><td>1</td><td>10801 Mastin St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>RYAN'S GRILL BUFFET BAKERY</td><td>1020 Discovery Rd</td><td>1</td><td>10864 Audelia Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BUFFETS HOLDINGS INC.</td><td>1020 Discovery Rd</td><td>1</td><td>10880 Benson St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>THE DOLLYWOOD COMPANY</td><td>1020 Dollywood Ln</td><td>2</td><td>1089 Little Britain Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>C H JAMES RESTAURANT HOLDINGS</td><td>1020 Milwaukee Ave</td><td>1</td><td>10897 NW 6th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>CH JAMES RESTAURANT HOLDINGS LLC</td><td>1020 Milwaukee Ave</td><td>2</td><td>109 N Kentucky Ave</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARKET PLACE INC.</td><td>1021 Cambridge Sq</td><td>4</td><td>109 New Camellia Blvd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MARKETPLACE HOLDINGS</td><td>1021 Cambridge Sq</td><td>2</td><td>109 W 17th St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCDONALD'S USA LLC</td><td>1021 Karl Greimel Dr</td><td>1</td><td>1090 W Georgia St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BODDIE-NOELL ENTERPRISES INC.</td><td>1021 Noell Ln</td><td>2</td><td>10930 W Potter Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>BODDIE-NOELL ENTERPRISES INC</td><td>1021 Noell Ln</td><td>2</td><td>10999 Petal St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>APEX RESTAURANT MANAGEMENT INC</td><td>1024 Serpentine Lane</td><td>1</td><td>11 Princess St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCESSY INVESTMENT COMPANY</td><td>1025 W Everett Rd</td><td>1</td><td>1100 Coiner CT</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>MCESSY INVESTMENT CO</td><td>1025 W Everett Rd</td><td>1</td><td>11005 Dover St</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr> <tr><td>STARBUCKS NORTHWEST INTERIOR REGIONAL OFFICE</td><td>10260 SW Greenburg Rd</td><td>2</td><td>1101 E Arapaho Rd</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td></td></tr></table>
Help!
Thanks,
Alex
