Spreadsheet: 546458d1510062144-cascading-drop-down-data-validation-lists-with-only-unique-items-remove-duplicates-breakdown-and-max-with-index
Sheet: Additional Remove

 |  |  |  |  | Match No | [NAME] For Array | Frequency | [NAME] | Small | Index | Error |  |  | check text | check code | match
 |  |  | Fred |  | 2 | 2 | 1 | 2 |  |  |  |  |  | True | 70 | 2
 |  |  | 12 |  | 3 | 3 | 0 |  |  |  |  |  |  | False | 49 | 0
 |  |  | [NAME] |  | 4 | 4 | 1 | 4 |  |  |  |  |  | True | 66 | 4
 |  |  | [NAME] |  | 1 | 5 | 0 |  |  |  |  |  |  | True | 68 | 1
 |  |  |  |  | 6 | 6 | 0 |  |  |  |  |  |  | True | #[NAME]! | 0
 |  |  | [NAME] |  | 7 | 7 | 1 | 7 |  |  |  |  |  | True | 66 | 7
 |  |  | 0 |  | 8 | 8 | 0 |  |  |  |  |  |  | False | 48 | 0
 |  |  |  |  | See Other Check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use this in Match No
 |  |  | FULLY DYNAMIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | check  text | check code | new match
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  | <<-- First
 |  | 2 | Fred |  | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  | True | 70 | 2
 |  | 3 | 12 |  | 0 | 3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | False | 49 | 0
 |  | 4 | [NAME] |  | 4 | 4 | 1 | 4 |  |  |  |  |  |  |  | <<-- Last |  |  |  | True | 66 | 4
 |  | 5 | [NAME] |  | 1 | 5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 1
 |  | 6 |  |  | 0 | 6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | #[NAME]! | 0
 |  | 7 | [NAME] |  | 7 | 7 | 2 | 7 |  |  |  |  |  |  |  | <<-- Full List |  |  |  | True | 66 | 7
 |  | 8 |  |  | 0 | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | False | #[NAME]! | 0
 |  | 9 | [NAME] |  | 9 | 9 | 2 | 9 |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 9
 |  | 10 | [NAME] |  | 1 | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 1
 |  | 11 | [NAME] |  | 11 | 11 | 1 | 11 |  |  |  |  |  |  |  |  |  |  |  | True | 66 | 11
 |  | 12 | Huw |  | 12 | 12 | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  | True | 72 | 12
 |  | 13 | [NAME] |  | 1 | 13 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 1
 |  | 14 | Fred |  | 2 | 14 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 70 | 2
 |  | 15 | [NAME] |  | 7 | 15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 66 | 7
 |  | 16 | [NAME] |  | 9 | 16 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 9
 |  | 17 | [NAME] |  | 17 | 17 | 1 | 17 |  |  |  |  |  |  |  |  |  |  |  | True | 66 | 17
 |  | 18 | [NAME] |  | 1 | 18 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 1
 |  | 19 | [NAME] |  | 19 | 19 | 1 | 19 |  |  |  |  |  |  |  |  |  |  |  | True | 72 | 19
 |  | 20 | [NAME] |  | 1 | 20 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | True | 68 | 1
 |  | 21 | [NAME] |  | 21 | 21 | 1 | 21 |  |  |  |  | Altered Checks to the MATCH Column  This Check Removes Blanks and Spaces from the initial list (which cause errors on the original removal page). Use OFFSET (or INDEX) and MAX ROW to create the Dynamic Range (instead of INDEX & COUNTIF)    The TEXT Check is not required when using the Dynamic Range |  |  |  |  |  |  | True | 67 | 21
 |  | 22 |  |  | 0 | 22 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | False | #[NAME]! | 0
 |  | 23 | [NAME] |  | 23 | 23 | 1 | 23 |  |  |  |  |  |  |  |  |  |  |  | True | 71 | 23
 |  | 24 | [NAME] |  | 24 | 24 | 1 | 24 |  |  |  |  |  |  |  |  |  |  |  | True | 70 | 24
 |  | 25 |  |  | 0 | #N/A | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 26 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 27 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 28 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 29 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 30 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 31 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 32 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0
 |  | 33 |  |  | 0 | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | False | #N/A | 0