Spreadsheet: 106300d1303478051-excel-2007-complex-sorting-and-countif-in-a-large-sheet-complex-sort
Sheet: Sheet1

 | A | B | R | E
 | State | Licence | owner | [NAME]
 | Florida | BEV6004497 | 7 ELEVEN INC | Convenience Grocery Store
 | Virginia |  | Random 7 | Convenience Grocery Store
 | Vermont | BEV2329282 | PAY AND SAVE INC. | Convenience Grocery Store/DIY
 | Vermont |  | Random 2 | Convenience Grocery Store/DIY
 | Oregon |  | Random 8 | Supermarket
 | Virginia | 749746 | TARGET CORPORATION | Supermarket/non-perishable
 | Washington | 717151 | BI-MART CORP | Supermarket/Discount
 | Washington |  | Random 3 | liquor Store
 | Maryland |  | Random 6 | Supermarket
 | Texas | 51100 | ADREST INC. | Gas-Convenience Grocery Store
 | Texas |  | Random | supermarket / dept store
 | Maryland | 12331172 | KMART CORPORATION | supermarket / dept store
 | Alabama |  | Random 4 | supermarket / dept store
 | Florida | BEV6004495 | Random 1 | Supermarket/Discount
 | North Carolina | 011-001716663 | ABC LIQUORS INC | State [NAME]
 | Oregon | 139761 | Wal-Mart | Supermarket
 | Sort |  | Sort | Count | Sort | Count
 | In state order | I am showing this as this column is unique for each row in the whole sheet | Owners sorted by most frequent in the state | owner Frequency  within state shown as a number | description Common as linked to owner | The Frequency of Description Commons
 | A | B | R |  | E
 | State | Licence | owner | Owner Frequency | [NAME] | D/C Frequency
 | Alabama | BEV6004496 | Random 4 | 1 | supermarket / dept store | 1
 | Florida | BEV6004497 | 7 ELEVEN INC | 1 | Convenience Grocery Store | 1
 | Florida | BEV6004498 | Random 1 | 1 | Supermarket/Discount | 1
 | Maryland | BEV6004499 | Random 6 | 1 | Supermarket | 1
 | Maryland | 12331172 | KMART CORPORATION | 1 | supermarket / dept store | 1
 | North Carolina | 011-001716663 | ABC LIQUORS INC | 1 | State [NAME] | 1
 | Oregon | 011-001716664 | Random 8 | 1 | Supermarket | 2
 | Oregon | 139761 | Wal-Mart | 1 | Supermarket | 2
 | Texas | 51100 | ADREST INC. | 1 | Gas-Convenience Grocery Store | 1
 | Texas | 65232 | Random | 1 | supermarket / dept store | 1
 | Virginia | 7169165 | Random 7 | 1 | Convenience Grocery Store | 1
 | Virginia | 749746 | TARGET CORPORATION | 1 | Supermarket/non-perishable | 1
 | Vermont | BEV2329282 | PAY AND SAVE INC. | 1 | Convenience Grocery Store/DIY | 2
 | Vermont | BEV2329283 | Random 2 | 1 | Convenience Grocery Store/DIY | 2
 | Washington | 717151 | BI-MART CORP | 1 | Supermarket/Discount | 1
 | Washington | 717152 | Random 3 | 1 | liquor Store | 1
 | Here is the case if they were just in one state.
 | A | B | R |  | E
 | State | Licence | owner | Owner Frequency | [NAME] | D/C Frequency
 | Alabama | BEV6004497 | 7 ELEVEN INC | 1 | Convenience Grocery Store | 2
 | Alabama | 7169165 | Random 7 | 1 | Convenience Grocery Store | 2
 | Alabama | BEV2329282 | PAY AND SAVE INC. | 1 | Convenience Grocery Store/DIY | 2
 | Alabama | BEV2329283 | Random 2 | 1 | Convenience Grocery Store/DIY | 2
 | Alabama | 51100 | ADREST INC. | 1 | Gas-Convenience Grocery Store | 1
 | Alabama | 717152 | Random 3 | 1 | liquor Store | 1
 | Alabama | 011-001716663 | ABC LIQUORS INC | 1 | State [NAME] | 1
 | Alabama | BEV6004499 | Random 6 | 1 | Supermarket | 3
 | Alabama | 011-001716664 | Random 8 | 1 | Supermarket | 3
 | Alabama | 139761 | Wal-Mart | 1 | Supermarket | 3
 | Alabama | BEV6004496 | Random 4 | 1 | supermarket / dept store | 3
 | Alabama | 12331172 | KMART CORPORATION | 1 | supermarket / dept store | 3
 | Alabama | 65232 | Random | 1 | supermarket / dept store | 3
 | Alabama | BEV6004498 | Random 1 | 1 | Supermarket/Discount | 2
 | Alabama | 717151 | BI-MART CORP | 1 | Supermarket/Discount | 2
 | Alabama | 749746 | TARGET CORPORATION | 1 | Supermarket/non-perishable | 1
 | Here is the case if they were just in one state.  If there are repetitions in the stores
 | A | B | R |  | E
 | State | Licence | owner | Owner Frequency | [NAME] | D/C Frequency
 | Alabama | BEV6004497 | 7 ELEVEN INC | 3 | Convenience Grocery Store | 4
 | Alabama | 7169165 | 7 ELEVEN INC | 3 | Convenience Grocery Store | 4
 | Alabama | BEV2329282 | 7 ELEVEN INC | 3 | Convenience Grocery Store | 4
 | Alabama | BEV2329283 | Another | 1 | Convenience Grocery Store | 4
 | Alabama | 51100 | ADREST INC. | 1 | Gas-Convenience Grocery Store | 1
 | Alabama | 717152 | Random 3 | 1 | liquor Store | 1
 | Alabama | 011-001716663 | ABC LIQUORS INC | 1 | State [NAME] | 1
 | Alabama | BEV6004499 | Random 6 | 1 | Supermarket | 3
 | Alabama | 011-001716664 | Random 8 | 1 | Supermarket | 3
 | Alabama | 139761 | Wal-Mart | 1 | Supermarket | 3
 | Alabama | BEV6004496 | Random 4 | 1 | supermarket / dept store | 3
 | Alabama | 12331172 | KMART CORPORATION | 1 | supermarket / dept store | 3
 | Alabama | 65232 | Random | 1 | supermarket / dept store | 3
 | Alabama | BEV6004498 | Random 1 | 1 | Supermarket/Discount | 2
 | Alabama | 717151 | BI-MART CORP | 1 | Supermarket/Discount | 2
 | Alabama | 749746 | TARGET CORPORATION | 1 | Supermarket/non-perishable | 1