Spreadsheet: 680475d1591039796-ranking-within-a-filtered-list-in-different-column-complete-community-study-sample-sheet
Sheet: STUDY

MARKET STUDY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add |  | add |  | add
NAME | City | State | Total Population | Population 65 - 74 | Population 75 + | % of Pop.  75 + | Buxton ALF Score | Buxton  MC Score | ALF  Units | 75 +  / Unit | MC  Units | 75 +  / Unit. | Total  Units | 75 +  / Unit, | 30 |  | 46 |  | 64
HIGHLAND CREST | Kirksville |  | 17968 | 1111 | 1107 | 0.06160952804986643 | 91 | 94 | 21 |  | 14
Rank
Results
Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * In the GREEN cells, I want to rank each BLUE cell above, within the BLUE column to the left.
Median |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If I filter the BLUE column to the left, I want the BLUE cells above to be ranked within the results leftover.
NAME | City | State | Total Population | Population 65 - 74 | Population 75 + | % of Pop.  75 + | Buxton ALF Score | Buxton  MC Score | ALF  Units | 75 +  / Unit | MC  Units | 75 +  / Unit. | Total  Units | 75 +  / Unit,
PARKWAY GARDENS | Fairview Heights | IL | 34738 | 3318 | 2595 |  | 110 | 87 | 122 |  | 24
ADAMS POINTE | Quincy | IL | 46850 | 4692 | 4657 |  | 121 | 89 | 163 |  | 51
CENTENNIAL POINTE | Springfield IL | IL | 126101 | 11878 | 9591 |  | 129 | 99 | 295 |  | 105
[NAME] | Great Bend | KS | 16781 | 1454 | 1452 |  | 122 | 121 | 80 |  | 0
WALDRON PLACE | Hutchinson | KS | 44877 | 4187 | 4171 |  | 106 | 107 | 156 |  | 144
MONTEREY VILLAGE | [NAME] | KS | 96664 | 5634 | 4031 |  | 106 | 77
CARRINGTON PLACE | Pittsburg | KS | 21233 | 1356 | 1217 |  | 102 | 95 | 118 |  | 35
[NAME] | Ashland | MO | 6504 | 534 | 416 |  | 73 | 87 | 48 |  | 0
HARTMANN VILLAGE | Boonville | MO | 9432 | 814 | 732 |  | 102 | 103 | 48 |  | 0
AUBURN CREEK | Cape Girardeau | MO | 42185 | 3309 | 3419 |  | 103 | 107
CAPETOWN | Cape Girardeau | MO | 42185 | 3309 | 3419 |  | 94 | 98
MAPLE TREE TERRACE | Carthage | MO | 18620 | 1490 | 1367 |  | 101 | 114 | 9 |  | 13
[NAME] | [NAME] | MO | 9455 | 944 | 1001 |  | 104 | 110 | 37 |  | 40
BLUFF CREEK TERRACE | Columbia | MO | 135141 | 7772 | 6012 |  | 116 | 93 | 401 |  | 44
COLONY POINT | Columbia | MO | 135141 | 7772 | 6012 |  | 128 | 114 | 401 |  | 44
MILL CREEK | Columbia | MO | 135141 | 7772 | 6012 |  | 113 | 84 | 401 |  | 44
TIGER PLACE | Columbia | MO | 135141 | 7772 | 6012 |  | 116 | 113 | 401 |  | 44
VP AT CUBA | Cuba | MO | 5560 | 577 | 486 |  | 92 | 94 | 36 |  | 32
[NAME] | Farmington | MO | 19784 | 1623 | 1550 |  | 96 | 108
MAPLEBROOK | Farmington | MO | 19784 | 1623 | 1550 |  | 99 | 116
CHURCHILL TERRACE | Fulton | MO | 14392 | 899 | 1020 |  | 81 | 105
VP OF HERMANN | Hermann | MO | 1920 | 356 | 370 |  | 100 | 119 | 36 |  | 0
WESTBROOK TERRACE | Jefferson City | MO | 50411 | 4440 | 3551 |  | 105 | 106
SILVER CREEK | [NAME] | MO | 73715 | 6412 | 5196 |  | 100 | 123
ST. FRANCIS PARK | Kennett | MO | 11066 | 1071 | 867 |  | 99 | 89
HIGHLAND CREST | Kirksville | MO | 17968 | 1111 | 1107 |  | 91 | 94 | 21 |  | 14
SUMMITVIEW TERRACE | [NAME]'s Summit | MO | 85889 | 7051 | 2052 |  | 97 | 90
WESTPORT ESTATES | [NAME] | MO | 13540 | 1083 | 953 |  | 102 | 108 | 69 |  | 14
TEAL LAKE | Mexico | MO | 12415 | 1115 | 1087 |  | 102 | 103 | 60 |  | 20
RAVENWOOD TERRACE | Moberly | MO | 16026 | 1289 | 1182 |  | 89 | 86 | 96 |  | 29
SPRINGHILL | Neosho | MO | 16426 | 1396 | 1241 |  | 95 | 119 | 110 |  | 20
BRADFORD COURT | Nixa | MO | 24602 | 2124 | 1546 |  | 107 | 76
VP OF OWENSVILLE | Owensville | MO | 4137 | 447 | 398 |  | 74 | 102 | 42 |  | 0
NORTHPARK VILLAGE | Ozark | MO | 15789 | 1260 | 906 |  | 94 | 82
RIVER MIST | Poplar Bluff | MO | 26338 | 2467 | 2233 |  | 121 | 115 | 73 |  | 0
LA BONNE MAISON | Sikeston | MO | 16823 | 1664 | 1399 |  | 87 | 93 | 24 |  | 26
LAKEWOOD | Springfield MO | MO | 232802 | 19946 | 17116 |  | 106 | 100 | 360 |  | 76
SPRINGRIDGE | Springfield MO | MO | 232802 | 19946 | 17116 |  | 97 | 92 | 360 |  | 76
RAVENWOOD | Springfield. MO | MO | 232802 | 19946 | 17116 |  | 111 | 107 | 360 |  | 76
VP OF ST. CLAIR | St. Clair | MO | 7641 | 580 | 563 |  | 86 | 87 | 64 |  | 14
[NAME] | St. Peters | MO | 66960 | 5941 | 3795 |  | 109 | 115 | 126 |  | 100
SPENCER PLACE | St. Peters | MO | 66960 | 5941 | 3795 |  | 106 | 118 | 126 |  | 100
PARKWOOD MEADOWS | Ste. Genevieve | MO | 4700 | 409 | 539 |  | 102 | 117 | 25 |  | 14
DUNSFORD COURT | [NAME] | MO | 9370 | 834 | 788 |  | 88 | 117 | 49 |  | 0
VP OF SULLIVAN | [NAME] | MO | 9370 | 834 | 788 |  | 99 | 93 | 49 |  | 0
SUGAR CREEK | Troy | MO | 13043 | 935 | 867 |  | 98 | 106 | 36 |  | 26
WILLOW BROOKE | Union | MO | 12943 | 1062 | 776 |  | 90 | 91 | 57 |  | 0
VP OF UNION | Union | MO | 12943 | 1062 | 776 |  | 94 | 92 | 57 |  | 0
VP OF VIENNA | Vienna | MO | 779 | 85 | 103 |  | 63 | 76 | 24 |  | 0
HARMONY GARDENS | Warrensburg | MO | 23037 | 1078 | 1281 |  | 96 | 103 | 70 |  | 16
SOUTH POINTE | Washington | MO | 15879 | 1501 | 1454 |  | 125 | 123 | 67 |  | 30
VP OF WASHINGTON | Washington | MO | 15879 | 1501 | 1454 |  | 131 | 121 | 67 |  | 30
FOXBERRY TERRACE | Webb City | MO | 23633 | 1838 | 1409 |  | 103 | 104
OLIVE GROVE TERRACE | Olive Branch | MS | 38272 | 2648 | 1650 |  | 103 | 89 | 122 |  | 39
MONTGOMERY GARDENS | Starkville | MS | 38532 | 1877 | 1682 |  | 85 | 86
DOGWOOD BEND | [NAME] | TN | 143225 | 6993 | 4629 |  | 85 | 84
SCHILLING GARDENS | Collierville | TN | 51426 | 4306 | 2173 |  | 93 | 89
PARKWAY COVE | Covington | TN | 9135 | 721 | 640 |  | 104 | 101 | 21 |  | 0
SOUTHERN OAKS | Henderson | TN | 7096 | 522 | 562 |  | 81 | 88
HARMONY HILL | Huntingdon | TN | 4017 | 506 | 382 |  | 84 | 102 | 27 |  | 0
ALEXANDRIA PLACE | [NAME] | TN | 61347 | 5142 | 4367 |  | 107 | 91 | 186 |  | 18
NORTHCLIFF | Lexington | TN | 8636 | 861 | 695 |  | 87 | 102
HICKORY GARDENS | [NAME] | TN | 88785 | 6466 | 5230 |  | 89 | 86
AUTUMN OAKS | [NAME] | TN | 12967 | 1173 | 1010 |  | 95 | 120 | 25 |  | 24
[NAME] | Martin | TN | 11413 | 782 | 777 |  | 98 | 101 | 25 |  | 0
RIVERVIEW TERRACE | McMinnville | TN | 16595 | 1585 | 1392 |  | 97 | 104 | 55 |  | 16
SOUTHBREEZE | Memphis | TN | 66663 | 7151 | 3478 |  | 103 | 92
PARK VIEW MEADOWS | Murfreesboro | TN | 147467 | 9226 | 6556 |  | 98 | 95
EIFFEL GARDENS | Paris | TN | 11329 | 1230 | 1249 |  | 98 | 117
ASBURY COVE | Ripley | TN | 9183 | 726 | 566 |  | 97 | 108
RIVERWICK | Savannah | TN | 8588 | 930 | 918 |  | 109 | 101 | 26 |  | 0
CELEBRATION WAY | Shelbyville | TN | 22798 | 1806 | 1362 |  | 106 | 101
AZELEA COURT | Smyrna | TN | 46786 | 3106 | 1827 |  | 108 | 101 | 93 |  | 40
WILLOW SPRINGS | Spring Hill | TN | 42273 | 2146 | 983 |  | 101 | 74
SPRINGFIELD HEIGHTS | Springfield TN | TN | 17973 | 1304 | 1232 |  | 110 | 113 | 70 |  | 0
THE ETHERIDGE HOUSE | Union City | TN | 11145 | 1130 | 968 |  | 102 | 114 | 57 |  | 16
MATURED ASSISTED LIVING
Matured - Excluding VP Facilities
DEVELOPMENT FACILITIES
ARBORS AT HARMONY GARDENS | Warrensburg | MO | 23037 | 1078 | 1281
HERITAGE PLACE | Lexington | TN | 8636 | 861 | 695
ARBORS AT PARKSIDE | Rolla | MO | 24807 | 1710 | 1567
PARKSIDE COTTAGES | Rolla | MO | 24807 | 1710 | 1567
PARKSIDE | Rolla | MO | 24807 | 1710 | 1567
DOGWOOD POINTE | Milan | TN | 8464 | 766 | 804
NORTHRIDGE PLACE | Lebanon | MO | 18470 | 1696 | 1440
ARBORS AT DOGWOOD POINTE | Milan | TN | 8464 | 766 | 804
MATTIS POINTE | St. Louis | MO | 71783 | 8938 | 8099
ARBORS AT MATTIS POINTE | St. Louis | MO | 71783 | 8938 | 8099
ARBORS AT CAPETOWN | Cape Girardeau | MO | 42185 | 3309 | 3419
DEVELOPMENT FACILITIES