Spreadsheet: 90798d1290532011-how-to-count-number-of-unique-occurrances-starting-with-a-text-string-office_rank_v2
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  | Values
List Number | Listing Office ID# | Selling Office | Listing Agent ID# | Selling Agent# | Raw_Listing | Raw_Selling | already appeared? RL | already appeared? RS | Clean listing | Clean selling |  | Listing Office Name | comp1 | count1 | dom1 | price1
3368771 | 5116 | 5113 | 10662 | 33432 | 5116_10662 | 5113_33432 | 0 | 0 | 5116_10662 | 5113_33432 |  | Coldwell Banker Burnet | 2.7 | 1 | 1067 | 3100000
3449402 | 3192 | 5113 | 74461 | 21149 | 3192_74461 | 5113_21149 | 0 | 0 | 3192_74461 | 5113_21149 |  | Coldwell Banker Burnet | 3 | 1 | 882 | 780000
3478616 | 11004 | 7317 | 80953 | 14489 | 11004_80953 | 7317_14489 | 0 | 0 | 11004_80953 | 7317_14489 |  | [NAME] | 0 | 1 | 805 | 21300
3480883 | 5148 | 6163 | 28672 | 21530 | 5148_28672 | 6163_21530 | 0 | 0 | 5148_28672 | 6163_21530 |  | Edina Realty, Inc. | 2.7 | 1 | 753 | 105000
3494129 | 5148 | 5148 | 10913 | 38060 | 5148_10913 | 5148_38060 | 0 | 0 | 5148_10913 | 5148_38060 |  | Coldwell Banker Burnet | 3 | 1 | 709 | 60000
3501444 | 6161 | 6082 | 34959 | 46124 | 6161_34959 | 6082_46124 | 0 | 0 | 6161_34959 | 6082_46124 |  | Edina Realty, Inc. | 2.7 | 1 | 863 | 141000
3503667 | 4135 | 1062 | 8085 | 80086 | 4135_8085 | 1062_80086 | 0 | 0 | 4135_8085 | 1062_80086 |  | RE/MAX Results | 2.7 | 1 | 710 | 228350
3503957 | 11034 | 11034 | 200846 | 85874 | 11034_200846 | 11034_85874 | 0 | 0 | 11034_200846 | 11034_85874 |  | fishMLS Realty | 2.7 | 1 | 850 | 165000
3506683 | 40130 | 5148 | 15410 | 28672 | 40130_15410 | 5148_28672 | 0 | 1 | 40130_15410 | Duplicate |  | Lakes Sotheby's International | 2.7 | 1 | 675 | 160000
3513566 | 5116 | 4014 | 30361 | 46731 | 5116_30361 | 4014_46731 | 0 | 0 | 5116_30361 | 4014_46731 |  | Coldwell Banker Burnet | 2.7 | 1 | 767 | 170000
3518233 | 9705 | 5126 | 97867 | 35619 | 9705_97867 | 5126_35619 | 0 | 0 | 9705_97867 | 5126_35619 |  | [NAME] Premier [NAME] | 2.5 | 1 | 713 | 35000
3526139 | 5011 | 10832 | 2022 | 91600 | 5011_2022 | 10832_91600 | 0 | 0 | 5011_2022 | 10832_91600 |  | Edina Realty, Inc. | 3.15 | 1 | 748 | 99000
3526406 | 11004 | 11004 | 83515 | 83515 | 11004_83515 | 11004_83515 | 0 | 1 | 11004_83515 | Duplicate |  | [NAME] | 2.7 | 1 | 740 | 184900
3528995 | 5177 | 1093 | 3599 | 80766 | 5177_3599 | 1093_80766 | 0 | 0 | 5177_3599 | 1093_80766 |  | Edina Realty, Inc. | 2.7 | 1 | 668 | 775250
3530592 | 5116 | 5116 | 4561 | 3588 | 5116_4561 | 5116_3588 | 0 | 0 | 5116_4561 | 5116_3588 |  | Coldwell Banker Burnet | 2.7 | 1 | 787 | 1650000
3532146 | 5116 | 5116 | 29280 | 29280 | 5116_29280 | 5116_29280 | 0 | 1 | 5116_29280 | Duplicate |  | Coldwell Banker Burnet | 3 | 1 | 775 | 1120000
3533656 | 5141 | 5141 | 4173 | 4173 | 5141_4173 | 5141_4173 | 0 | 1 | 5141_4173 | Duplicate |  | Coldwell Banker Burnet | 2.7 | 1 | 778 | 750000
3534683 | 5126 | 5126 | 33885 | 1497 | 5126_33885 | 5126_1497 | 0 | 0 | 5126_33885 | 5126_1497 |  | Coldwell Banker Burnet | 2.7 | 1 | 716 | 675000
3537674 | 5141 | 5331 | 9689 | 27752 | 5141_9689 | 5331_27752 | 0 | 0 | 5141_9689 | 5331_27752 |  | Coldwell Banker Burnet | 2.5 | 1 | 730 | 680000
3538532 | 6161 | 5057 | 34959 | 28115 | 6161_34959 | 5057_28115 | 1 | 0 | Duplicate | 5057_28115 |  | Edina Realty, Inc. | 2.7 | 1 | 742 | 135000
3551962 | 5011 | 5116 | 2022 | 21213 | 5011_2022 | 5116_21213 | 1 | 0 | Duplicate | 5116_21213 |  | Edina Realty, Inc. | 3.15 | 1 | 710 | 70000
3552822 | 5011 | 5177 | 28576 | 29808 | 5011_28576 | 5177_29808 | 0 | 0 | 5011_28576 | 5177_29808 |  | Edina Realty, Inc. | 2.7 | 1 | 756 | 335000
3569190 | 5141 | 5141 | 2001 | 31682 | 5141_2001 | 5141_31682 | 0 | 0 | 5141_2001 | 5141_31682 |  | Coldwell Banker Burnet | 2.7 | 1 | 638 | 557000
3569849 | 6161 | 5917 | 34959 | 16416 | 6161_34959 | 5917_16416 | 1 | 0 | Duplicate | 5917_16416 |  | Edina Realty, Inc. | 2.7 | 1 | 659 | 118500
3572738 | 5020 | 6082 | 3841 | 25025 | 5020_3841 | 6082_25025 | 0 | 0 | 5020_3841 | 6082_25025 |  | The Realty House | 3 | 1 | 653 | 85000
3573732 | 7105 | 7432 | 17551 | 33851 | 7105_17551 | 7432_33851 | 0 | 0 | 7105_17551 | 7432_33851 |  | Re/Max A-1 Excellence | 2.6 | 1 | 573 | 179000
3573934 | 5116 | 6508 | 14740 | 25845 | 5116_14740 | 6508_25845 | 0 | 0 | 5116_14740 | 6508_25845 |  | Coldwell Banker Burnet | 2.7 | 1 | 650 | 300000
3574201 | 5116 | 5877 | 4561 | 27874 | 5116_4561 | 5877_27874 | 1 | 0 | Duplicate | 5877_27874 |  | Coldwell Banker Burnet | 2.7 | 1 | 679 | 425000
3582076 | 6274 | 5126 | 42768 | 42943 | 6274_42768 | 5126_42943 | 0 | 0 | 6274_42768 | 5126_42943 |  | RE/MAX Results | 2.9 | 1 | 660 | 157000
3582432 | 3276 | 11034 | RAmland | 87904 | 3276_RAmland | 11034_87904 | 0 | 0 | 3276_RAmland | 11034_87904 |  | [NAME] Integrity Rlty | 3 | 1 | 672 | 75000
3583566 | 6387 | 11392 | 27375 | 88230 | 6387_27375 | 11392_88230 | 0 | 0 | 6387_27375 | 11392_88230 |  | Wright-Sherburne Realty | 3 | 1 | 717 | 104000
3587918 | 1062 | 5878 | 80086 | 46358 | 1062_80086 | 5878_46358 | 1 | 0 | Duplicate | 5878_46358 |  | Prudential Sundial Realty | 2.7 | 1 | 618 | 500000
3588983 | 5116 | 5116 | 29278 | 29278 | 5116_29278 | 5116_29278 | 0 | 1 | 5116_29278 | Duplicate |  | Coldwell Banker Burnet | 2.7 | 1 | 616 | 1750000
3594053 | 5011 | 5116 | 2989 | 12640 | 5011_2989 | 5116_12640 | 0 | 0 | 5011_2989 | 5116_12640 |  | Edina Realty, Inc. | 2.7 | 1 | 508 | 485000
3595477 | 7105 | 7231 | 5804 | 45982 | 7105_5804 | 7231_45982 | 0 | 0 | 7105_5804 | 7231_45982 |  | Re/Max A-1 Excellence | 2.7 | 1 | 577 | 530000
3599257 | 7105 | 10341 | 17551 | 65026 | 7105_17551 | 10341_65026 | 1 | 0 | Duplicate | 10341_65026 |  | Re/Max A-1 Excellence | 2.5 | 1 | 653 | 335000
3601868 | 5353 | 3957 | 32956 | 73522 | 5353_32956 | 3957_73522 | 0 | 0 | 5353_32956 | 3957_73522 |  | RE/MAX Results | 3 | 1 | 478 | 185000
3602981 | 11004 | 6082 | 80953 | 42145 | 11004_80953 | 6082_42145 | 1 | 0 | Duplicate | 6082_42145 |  | [NAME] | 0 | 1 | 579 | 80000
3605898 | 11004 | 5353 | 80953 | 35518 | 11004_80953 | 5353_35518 | 1 | 0 | Duplicate | 5353_35518 |  | [NAME] | 5 | 1 | 473 | 95000
3605939 | 11004 | 11004 | 80953 | 80953 | 11004_80953 | 11004_80953 | 1 | 1 | Duplicate | Duplicate |  | [NAME] | 5 | 1 | 469 | 13000
3606871 | 11171 | 11171 | 89294 | 89294 | 11171_89294 | 11171_89294 | 0 | 1 | 11171_89294 | Duplicate |  | [NAME] Northwest | 2.7 | 1 | 607 | 130900
3608283 | 4135 | 1118 | 17724 | 88159 | 4135_17724 | 1118_88159 | 0 | 0 | 4135_17724 | 1118_88159 |  | RE/MAX Results | 2.7 | 1 | 469 | 236100
3611499 | 5302 | 7429 | 31689 | 42745 | 5302_31689 | 7429_42745 | 0 | 0 | 5302_31689 | 7429_42745 |  | [NAME], Inc | 2.7 | 1 | 618 | 270000
3611681 | 5116 | 5116 | 5208 | 34539 | 5116_5208 | 5116_34539 | 0 | 0 | 5116_5208 | 5116_34539 |  | Coldwell Banker Burnet | 2.7 | 1 | 604 | 3125000
3611724 | 5141 | 12360 | 8011 | 76702 | 5141_8011 | 12360_76702 | 0 | 0 | 5141_8011 | 12360_76702 |  | Coldwell Banker Burnet | 2.5 | 1 | 597 | 176300