Spreadsheet: 75651d1276188099-summarizing-data-test
Sheet: Sheet1

 |  |  | Evaluate these cells and compile a list of unique values in cells M9:M100 exluding blank cells and duplicate entries.
 |  |  |  |  |  |  |  |  |  |  |  |  | M8: (to give count of unique terms)
 |  |  |  |  |  |  |  |  |  |  |  | 44 | 44
1 | 1 | 1101-F/3 | 197166 | 1101_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1101-F/3 | SUMPRODUCT(($C$9:$C$105<>"")/COUNTIF($C$9:$C$105,$C$9:$C$105&""))
 | 2-3 | 6601-F/3 | 197545 | 6601_3_84_325/CT | 72 | 72 | 84 |  |  |  |  | 1101-F/3 | M9:
 | 4-6 | 1131-F/3 | 197198 | 1131_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1101-F/3 | #N/A
 | 7-8 | 1151-F/3 | 197820 | 1151_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 6601-F/3 | copied down as far as required
 | 9-11 | 1130-F/3 | 197193 | 1130_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 6601-F/3
 | 12-13 | 6640-F/3 | 197574 | 6640_3_84_325/CT | 73 | 73 | 84 |  |  |  |  | 6601-F/3 | IF(ROWS(M$9:[NAME])))
 | 14-22 | 1182-F/5 | 197475 | 1182_5_84_325/CT | 76 | 76 | 84 |  |  |  |  | 1131-F/3
 | 23-24 | 6620-F/3 | 197559 | 6620_3_84_325/CT | 73 | 73 | 84 |  |  |  |  | 1131-F/3
 | 25-27 | 1180-F/5 | 197453 | 1180_5_84_325/CT | 76 | 76 | 84 |  |  |  |  | 1131-F/3
 | 28-30 | 1181-F/3 | 197460 | 1181_3_84_325/CT | 72 | 72 | 84 |  |  |  |  | 1151-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 1151-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 1151-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 1130-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 1130-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 1130-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 6640-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 6640-F/3
 |  |  |  |  |  |  |  |  |  |  |  | 6640-F/3
2 | 31-33 | 1173-F/3 | 197383 | 1173_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1182-F/5
 | 34-35 | 443-F/3 | 201161 | 443_3_84_325/CT | 68 | 68 | 84 |  |  |  |  | 1182-F/5
 | 36-38 | 1172-F/3 | 197216 | 1172_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1182-F/5
 | 39-41 | 1171-F/3 | 197211 | 1171_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 6620-F/3
 | 42-44 | 1181-F/5 | 197464 | 1181_5_84_325/CT | 76 | 76 | 84 |  |  |  |  | 6620-F/3
 | 45-46 | 443-F/3 | 201161 | 443_3_84_325/CT | 68 | 68 | 84 |  |  |  |  | 6620-F/3
 | 47 | 1102-F/3 | 197183 | 1102_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1180-F/5
 | 48 | 1103-F/3 | 197189 | 1103_3_84_325/CT | 82 | 82 | 84 |  |  |  |  | 1180-F/5
 | 49-51 | 1173-F/5 | 197386 | 1173_5_84_325/CT | 92 | 92 | 84 |  |  |  |  | 1181-F/3
 | 52-57 | 1170-F/5 | 197208 | 1170_5_84_325/CT | 92 | 92 | 84 |  |  |  |  | 1181-F/3
 | 58-60 | 1181-F/5 | 197464 | 1181_5_84_325/CT | 76 | 76 | 84 |  |  |  |  | 1173-F/3
3 | 61-62 | 6641-F/3 | 197578 | 6641_3_84_325/CT | 73 | 73 | 84
 | 63-64 | 6621-F/3 | 197570 | 6621_3_84_325/CT | 73 | 73 | 84
 | 65 | 6600-F/3 | 197564 | 6600_3_84_325/CT | 72 | 72 | 84
 | 66-70 | 1170-F/4 | 197207 | 1170_4_84_325/CT | 88 | 88 | 84
 | 71 | 1151-F/4 | 197821 | 1151_4_84_325/CT | 88 | 88 | 84
 | 72-74 | 443-F/3 | 201161 | 443_3_84_325/CT | 68 | 68 | 84
 | 75-76 | 6602-F/3 | 197549 | 6602_3_84_325/CT | 72 | 72 | 84
 | 77-80 | 1182-F/5 | 197475 | 1182_5_84_325/CT | 76 | 76 | 84
 | 81-83 | 1180-F/3 | 197451 | 1180_3_84_325/CT | 72 | 72 | 84
 | 84-86 | 1182-F/5 | 197475 | 1182_5_84_325/CT | 76 | 76 | 84
 | 87-90 | 1151-F/4 | 197821 | 1151_4_84_325/CT | 88 | 88 | 84
4 | 91-92 | 1131-84/3 | 203961 | 1131_3_84_35/CT | 0 | 62 | 84
 | 93-95 | 798-84/6 | 197044 | 798_6_84_35/CT | 74 | 74 | 84
 | 96-97 | 6503-84/6 | 197532 | 6503_6_84_35/CT | 62 | 62 | 84
 | 98-99 | 6506-84/6 | 197560 | 6506_6_84_35/CT | 0 | 62 | 84
 | 100-101 | 6501-84/6 | 197517 | 6501_6_84_35/CT | 62 | 62 | 84
 | 102-105 | 6505-84/6 | 197556 | 6505_6_84_35/CT | 62 | 62 | 84
 | 106-116 | 322-84/5 | 195850 | 322_5_84_35/CT | 55.5 | 55.5 | 84
 | 117-120 | 1130-84/3 | 203960 | 1130_3_84_35/CT | 0 | 62 | 84
5 | 121 | 6502-84/6 | 197529 | 6502_6_84_35/CT | 62 | 62 | 84
 | 122-123 | 6504-84/6 | 197553 | 6504_6_84_35/CT | 62 | 62 | 84
 | 124-129 | 797-84/6 | 197040 | 797RED_6_84_35/CT | 74 | 74 | 84
 | 130-143 | 322-84/5 | 195850 | 322_5_84_35/CT | 55.5 | 55.5 | 84
 | 144-146 | 1130-84/4 | 197195 | 1130_4_84_35/CT | 57 | 57 | 84
 | 147-149 | 1131-84/4 | 197199 | 1131_4_84_35/CT | 57 | 57 | 84
 | 150 | 6502-84/6 | 197529 | 6502_6_84_35/CT | 62 | 62 | 84
6 | 151-165 | 5400-US/3 | 201177 | 5400_3_84_35/OT | 49 | 49 | 84
 | 166-180 | 5401-US/3 | 203449 | 5401_3_84_35/OT | 49 | 49 | 84
7 | 181-184 | 5401-US/3 | 203449 | 5401_3_84_35/OT | 49 | 49 | 84
 | 185-197 | 5402-US/3 | 203455 | 5402_3_84_35/OT | 49 | 49 | 84
 | 198-205 | 5410-US/3 | 203577 | 5410_3_84_35/OT | 53 | 53 | 84
 | 206-210 | 5411-US/3 | 203578 | 5411_3_84_35/OT | 53 | 53 | 84