Spreadsheet: 90726d1290493098-how-to-count-number-of-unique-occurrances-starting-with-a-text-string-rankingtest
Sheet: Data

 |  |  |  |  |  | Values
List Number | Listing Office ID# | Selling Office | Listing Agent ID# | Selling Agent# | Listing Office Name | comp1 | count1 | dom1 | price1
3368771 | 5116 | 5113 | 10662 | 33432 | Coldwell Banker Burnet | 2.7 | 1 | 1067 | 3100000
3449402 | 3192 | 5113 | 74461 | 21149 | Coldwell Banker Burnet | 3 | 1 | 882 | 780000
3478616 | 11004 | 7317 | 80953 | 14489 | [NAME] | 0 | 1 | 805 | 21300
3480883 | 6161 | 6163 | 34959 | 21530 | Edina Realty, Inc. | 2.7 | 1 | 753 | 105000
3494129 | 5148 | 5148 | 10913 | 38060 | Coldwell Banker Burnet | 3 | 1 | 709 | 60000
3501444 | 6161 | 6082 | 34959 | 46124 | Edina Realty, Inc. | 2.7 | 1 | 863 | 141000
3503667 | 4135 | 1062 | 8085 | 80086 | RE/MAX Results | 2.7 | 1 | 710 | 228350
3503957 | 11034 | 11034 | 200846 | 85874 | fishMLS Realty | 2.7 | 1 | 850 | 165000
3506683 | 40130 | 5148 | 15410 | 28672 | Lakes Sotheby's International | 2.7 | 1 | 675 | 160000
3513566 | 5116 | 4014 | 30361 | 46731 | Coldwell Banker Burnet | 2.7 | 1 | 767 | 170000
3518233 | 9705 | 5126 | 97867 | 35619 | [NAME] Premier [NAME] | 2.5 | 1 | 713 | 35000
3526139 | 5011 | 10832 | 2022 | 91600 | Edina Realty, Inc. | 3.15 | 1 | 748 | 99000
3526406 | 11004 | 11004 | 83515 | 83515 | [NAME] | 2.7 | 1 | 740 | 184900
3528995 | 5177 | 1093 | 3599 | 80766 | Edina Realty, Inc. | 2.7 | 1 | 668 | 775250
3530592 | 5116 | 5116 | 4561 | 3588 | Coldwell Banker Burnet | 2.7 | 1 | 787 | 1650000
3532146 | 5116 | 5116 | 29280 | 29280 | Coldwell Banker Burnet | 3 | 1 | 775 | 1120000
3533656 | 5141 | 5141 | 4173 | 4173 | Coldwell Banker Burnet | 2.7 | 1 | 778 | 750000
3534683 | 5126 | 5126 | 33885 | 1497 | Coldwell Banker Burnet | 2.7 | 1 | 716 | 675000
3537674 | 5141 | 5331 | 9689 | 27752 | Coldwell Banker Burnet | 2.5 | 1 | 730 | 680000
3538532 | 6161 | 5057 | 34959 | 28115 | Edina Realty, Inc. | 2.7 | 1 | 742 | 135000
3551962 | 5011 | 5116 | 2022 | 21213 | Edina Realty, Inc. | 3.15 | 1 | 710 | 70000
3552822 | 5011 | 5177 | 28576 | 29808 | Edina Realty, Inc. | 2.7 | 1 | 756 | 335000
3569190 | 5141 | 5141 | 2001 | 31682 | Coldwell Banker Burnet | 2.7 | 1 | 638 | 557000
3569849 | 6161 | 5917 | 34959 | 16416 | Edina Realty, Inc. | 2.7 | 1 | 659 | 118500
3572738 | 5020 | 6082 | 3841 | 25025 | The Realty House | 3 | 1 | 653 | 85000
3573732 | 7105 | 7432 | 17551 | 33851 | Re/Max A-1 Excellence | 2.6 | 1 | 573 | 179000
3573934 | 5116 | 6508 | 14740 | 25845 | Coldwell Banker Burnet | 2.7 | 1 | 650 | 300000
3574201 | 5116 | 5877 | 4561 | 27874 | Coldwell Banker Burnet | 2.7 | 1 | 679 | 425000
3582076 | 6274 | 5126 | 42768 | 42943 | RE/MAX Results | 2.9 | 1 | 660 | 157000
3582432 | 3276 | 11034 | RAmland | 87904 | [NAME] Integrity Rlty | 3 | 1 | 672 | 75000
3583566 | 6387 | 11392 | 27375 | 88230 | Wright-Sherburne Realty | 3 | 1 | 717 | 104000
3587918 | 1062 | 5878 | 80086 | 46358 | Prudential Sundial Realty | 2.7 | 1 | 618 | 500000
3588983 | 5116 | 5116 | 29278 | 29278 | Coldwell Banker Burnet | 2.7 | 1 | 616 | 1750000
3594053 | 5011 | 5116 | 2989 | 12640 | Edina Realty, Inc. | 2.7 | 1 | 508 | 485000
3595477 | 7105 | 7231 | 5804 | 45982 | Re/Max A-1 Excellence | 2.7 | 1 | 577 | 530000
3599257 | 7105 | 10341 | 17551 | 65026 | Re/Max A-1 Excellence | 2.5 | 1 | 653 | 335000
3601868 | 5353 | 3957 | 32956 | 73522 | RE/MAX Results | 3 | 1 | 478 | 185000
3602981 | 11004 | 6082 | 80953 | 42145 | [NAME] | 0 | 1 | 579 | 80000
3605898 | 11004 | 5353 | 80953 | 35518 | [NAME] | 5 | 1 | 473 | 95000
3605939 | 11004 | 11004 | 80953 | 80953 | [NAME] | 5 | 1 | 469 | 13000
3606871 | 11171 | 11171 | 89294 | 89294 | [NAME] Northwest | 2.7 | 1 | 607 | 130900
3608283 | 4135 | 1118 | 17724 | 88159 | RE/MAX Results | 2.7 | 1 | 469 | 236100
3611499 | 5302 | 7429 | 31689 | 42745 | [NAME], Inc | 2.7 | 1 | 618 | 270000
3611681 | 5116 | 5116 | 5208 | 34539 | Coldwell Banker Burnet | 2.7 | 1 | 604 | 3125000
3611724 | 5141 | 12360 | 8011 | 76702 | Coldwell Banker Burnet | 2.5 | 1 | 597 | 176300