Spreadsheet: 131365d1322927783-unique-rank-with-two-criteria-021211-v2-
Sheet: ProfileYear

No | Summer-2011 |  |  |  |  |  |  | Validation List for B1 > | Summer-2011
 |  |  |  |  |  |  |  |  | Winter-2010
 |  |  |  |  |  |  |  |  | Winter-2011
 |  |  |  | Sum of Availability <100%
Ref | FILTERED RANK | FILTERED TOTALS | Group | Profile-Year | Code | Total
No | 1 | 1 | 1 | Summer-2011 | 4080 | 1
Yes |  |  | 1 |  | 1022 | 0
No | 3 | 0 | 1 |  | 0127 | 0
No | 4 | 0 | 1 |  | 0000 | 0
No | 5 | 0 | 1 |  | 0024 | 0
No | 2 | 1 | 1 |  | 2437 | 1
No | 6 | 0 | 1 |  | 8140 | 0
No | 7 | 0 | 1 |  | 2131 | 0
No | 8 | 0 | 1 |  | 7909 | 0
No | 9 | 0 | 1 |  | 0110 | 0
No | 10 | 0 | 1 |  | 0242 | 0
Yes |  |  | 1 |  | 0154 | 2
No | 11 | 0 | 1 |  | 0156 | 0
Yes |  |  | 1 |  | 0152 | 0
Yes |  |  | 1 |  | 0137 | 3
Yes |  |  | 1 |  | 0138 | 2
Yes |  |  | 1 |  | 0153 | 5
Yes |  |  | 1 |  | 0155 | 3
No | 12 | 0 | 1 |  | 1013 | 0
Yes |  |  | 1 |  | 1005 | 0
Yes |  |  | 1 |  | 1004 | 0
Yes |  |  | 1 |  | 1006 | 0
Yes |  |  | 1 |  | 1892 | 0
Yes |  |  | 1 |  | 0041 | 0
Yes |  |  | 1 |  | 0040 | 1
No |  |  | 2 | Winter-2010 | 4080 | 0
Yes |  |  | 2 |  | 1022 | 0
No |  |  | 2 |  | 0127 | 1
No |  |  | 2 |  | 0000 | 0
No |  |  | 2 |  | 0024 | 0
No |  |  | 2 |  | 2437 | 0
No |  |  | 2 |  | 8140 | 1
No |  |  | 2 |  | 2131 | 0
No |  |  | 2 |  | 7909 | 0
No |  |  | 2 |  | 0110 | 0
No |  |  | 2 |  | 0164 | 0
Yes |  |  | 2 |  | 0154 | 0
No |  |  | 2 |  | 0156 | 0
Yes |  |  | 2 |  | 0152 | 0
Yes |  |  | 2 |  | 0137 | 3
Yes |  |  | 2 |  | 0138 | 0
Yes |  |  | 2 |  | 0153 | 1
Yes |  |  | 2 |  | 0155 | 0
No |  |  | 2 |  | 1013 | 0
No |  |  | 3 | Winter-2011 | 4080 | 0
Yes |  |  | 3 |  | 1022 | 0
No |  |  | 3 |  | 0127 | 0
No |  |  | 3 |  | 0000 | 2
No |  |  | 3 |  | 2437 | 0
No |  |  | 3 |  | 8140 | 0
No |  |  | 3 |  | 2131 | 0
No |  |  | 3 |  | 3700 | 0
No |  |  | 3 |  | 7909 | 0
No |  |  | 3 |  | 0242 | 0
Yes |  |  | 3 |  | 0154 | 0
No |  |  | 3 |  | 0156 | 1
Yes |  |  | 3 |  | 0152 | 1
Yes |  |  | 3 |  | 0137 | 0
Yes |  |  | 3 |  | 0138 | 0
Yes |  |  | 3 |  | 0153 | 0
Yes |  |  | 3 |  | 0155 | 0
Yes |  |  | 3 |  | 0041 | 0
Yes |  |  | 3 |  | 0040 | 0
Yes |  |  | 3 |  | 0141 | 0
Yes |  |  | 3 |  | 0142 | 0
Yes |  |  | 3 |  | 0148 | 0
Yes |  |  | 3 |  | 0147 | 0
Yes |  |  | 3 |  | 0143 | 0
Yes |  |  | 3 |  | 0144 | 0
No |  |  | 3 |  | 0150 | 0
Yes |  |  | 3 |  | 0149 | 0
Yes |  |  | 3 |  | 0139 | 10
Yes |  |  | 3 |  | 0140 | 3
No |  |  | 3 |  | 0146 | 0
Yes |  |  | 3 |  | 0145 | 1
Yes |  |  | 3 |  | 1895 | 0
Yes |  |  | 3 |  | 1891 | 1
Yes |  |  | 3 |  | 1636 | 0
Yes |  |  | 3 |  | 1890 | 0
Yes |  |  | 3 |  | 1893 | 0
Yes |  |  | 3 |  | 1888 | 0
No |  |  | 3 |  | 0168 | 2
No |  |  | 3 |  | 0170 | 0
No |  |  | 3 |  | 0171 | 9
Yes |  |  | 3 |  | 1021 | 0
Yes |  |  | 3 |  | 1023 | 0
Yes |  |  | 3 |  | 1024 | 4
Yes |  |  | 3 |  | 1017 | 0
Yes |  |  | 3 |  | 1018 | 1
Yes |  |  | 3 |  | 1019 | 0
Yes |  |  | 3 |  | 1020 | 0
Yes |  |  | 3 |  | 0442 | 0
No |  |  | 3 |  | 0441 | 0
No |  |  | 3 |  | 0105 | 0
No |  |  | 3 |  | 0106 | 0
No |  |  | 3 |  | 0107 | 0
No |  |  | 3 |  | 0108 | 0
No |  |  | 3 |  | 0109 | 0
No |  |  | 3 |  | 0110 | 0
No |  |  | 3 |  | 0111 | 1
No |  |  | 3 |  | 0112 | 0
No |  |  | 3 |  | 0113 | 0
No |  |  | 3 |  | 0114 | 0
No |  |  | 3 |  | 0115 | 0
No |  |  | 3 |  | 0116 | 0
No |  |  | 3 |  | 0117 | 0
No |  |  | 3 |  | 0118 | 0
No |  |  | 3 |  | 0119 | 0
No |  |  | 3 |  | 0095 | 2
No |  |  | 3 |  | 0101 | 5
No |  |  | 3 |  | 0103 | 0
No |  |  | 3 |  | 0104 | 0
No |  |  | 3 |  | 0097 | 0
No |  |  | 3 |  | 0098 | 0
No |  |  | 3 |  | 0099 | 0
No |  |  | 3 |  | 0124 | 0
No |  |  | 3 |  | 0125 | 0
No |  |  | 3 |  | 2033 | 1
No |  |  | 3 |  | 0032 | 0
No |  |  | 3 |  | 0033 | 0
No |  |  | 3 |  | 0034 | 0
No |  |  | 3 |  | 0035 | 0
No |  |  | 3 |  | 0036 | 0
No |  |  | 3 |  | 0062 | 3
No |  |  | 3 |  | 0064 | 0
No |  |  | 3 |  | 0043 | 0
No |  |  | 3 |  | 0044 | 0
No |  |  | 3 |  | 0045 | 2
No |  |  | 3 |  | 0046 | 0
No |  |  | 3 |  | 0047 | 0
No |  |  | 3 |  | 0049 | 0
No |  |  | 3 |  | 2430 | 0
No |  |  | 3 |  | 2432 | 0
No |  |  | 3 |  | 3702 | 0
No |  |  | 3 |  | 2431 | 0
No |  |  | 3 |  | 3665 | 0
No |  |  | 3 |  | 3664 | 0
No |  |  | 3 |  | 3666 | 2
No |  |  | 3 |  | 2433 | 0
No |  |  | 3 |  | 2434 | 1
No |  |  | 3 |  | 2435 | 0
No |  |  | 3 |  | 1155 | 4
No |  |  | 3 |  | 1156 | 1
No |  |  | 3 |  | 1157 | 0
No |  |  | 3 |  | 1086 | 0
No |  |  | 3 |  | 1087 | 0
No |  |  | 3 |  | 1088 | 0
No |  |  | 3 |  | 1089 | 0
No |  |  | 3 |  | 1090 | 0
No |  |  | 3 |  | 1091 | 0
No |  |  | 3 |  | 1082 | 0
No |  |  | 3 |  | 1083 | 1
No |  |  | 3 |  | 1092 | 3
No |  |  | 3 |  | 1084 | 0
No |  |  | 3 |  | 1085 | 0
No |  |  | 3 |  | 2066 | 0
No |  |  | 3 |  | 2067 | 4
No |  |  | 3 |  | 2068 | 0
No |  |  | 3 |  | 2506 | 1
No |  |  | 3 |  | 2505 | 0
No |  |  | 3 |  | 2824 | 0
No |  |  | 3 |  | 2036 | 0
No |  |  | 3 |  | 2037 | 0
No |  |  | 3 |  | 2038 | 1
No |  |  | 3 |  | 2409 | 0
No |  |  | 3 |  | 2607 | 1
No |  |  | 3 |  | 2686 | 8
No |  |  | 3 |  | 2608 | 1
No |  |  | 3 |  | 0084 | 3
No |  |  | 3 |  | 0076 | 0
No |  |  | 3 |  | 0077 | 0
No |  |  | 3 |  | 0066 | 0
No |  |  | 3 |  | 0067 | 0
No |  |  | 3 |  | 0068 | 1
No |  |  | 3 |  | 0069 | 0
No |  |  | 3 |  | 0080 | 0
No |  |  | 3 |  | 0070 | 1
No |  |  | 3 |  | 0057 | 0
No |  |  | 3 |  | 0053 | 0
No |  |  | 3 |  | 0054 | 5
No |  |  | 3 |  | 0055 | 0