Spreadsheet: 811784d1672787713-i-need-to-have-manual-data-track-a-unique-dynamic-list-book2
Sheet: Sheet1

ORIGINAL
DATASET |  |  |  |  |  |  |  |  |  | DYNMAIC LIST | MANUAL DATA
NAMES | COLOR1 | COLOR2 | COLOR3 | COLOR4 | COLOR5 |  |  |  |  | UNIQUE LIST | COLOR CODE
[NAME] | RED | GREEN | BLUE |  |  |  |  |  |  |  | 2
RODNEY | PURPLE | RED | BLACK |  |  |  |  |  |  | GREEN | 4
NICK | GREEN | BLUE | RED | YELLOW |  |  |  |  |  | BLUE | 8
[NAME] | RED | ORANGE | PINK |  |  |  |  |  |  | PURPLE | 16
[NAME] | VIOLET | GREEN | BLUE |  |  |  |  |  |  | BLACK | 32
RICHARD | ORANGE | PURPLE | PINK | RED | YELLOW |  |  |  |  | YELLOW | 64
 |  |  |  |  |  |  |  |  |  | ORANGE | 128
 |  |  |  |  |  |  |  |  |  | PINK | 256
 |  |  |  |  |  |  |  |  |  | VIOLET | 512
MODIFIED - DATASET CHANGED
DATASET |  |  |  |  |  |  |  |  |  | DYNMAIC LIST | MANUAL DATA
NAMES | COLOR1 | COLOR2 | COLOR3 | COLOR4 | COLOR5 |  |  |  |  | UNIQUE LIST | COLOR CODE
[NAME] | RED | GREEN | BLUE | BROWN | GREY |  |  |  |  |  | 2
RODNEY | PURPLE | RED | BLACK |  |  |  |  |  |  | GREEN | 4
NICK | GREEN | BLUE | RED | YELLOW | ORANGE |  |  |  |  | BLUE | 8
[NAME] | RED | ORANGE | PINK |  |  |  |  |  |  | BROWN | 16 |  | As the dataset is update the manual values that were previously entered no longer correspond
[NAME] | VIOLET | GREEN | BLUE |  |  |  |  |  |  | GREY | 32
RICHARD | ORANGE | PURPLE | PINK | RED | YELLOW |  |  |  |  | PURPLE | 64
 |  |  |  |  |  |  |  |  |  | BLACK | 128
 |  |  |  |  |  |  |  |  |  | YELLOW | 256
 |  |  |  |  |  |  |  |  |  | ORANGE | 512
 |  |  |  |  |  |  |  |  |  | PINK
 |  |  |  |  |  |  |  |  |  | VIOLET
DESIRED RESULT EXAMPLE #1
DATASET |  |  |  |  |  |  |  |  |  | DYNMAIC LIST | MANUAL DATA
NAMES | COLOR1 | COLOR2 | COLOR3 | COLOR4 | COLOR5 |  |  |  |  | UNIQUE LIST | COLOR CODE
[NAME] | RED | GREEN | BLUE | BROWN | GREY |  |  |  |  |  | 2
RODNEY | PURPLE | RED | BLACK |  |  |  |  |  |  | GREEN | 4
NICK | GREEN | BLUE | RED | YELLOW | ORANGE |  |  |  |  | BLUE | 8
[NAME] | RED | ORANGE | PINK |  |  |  |  |  |  | BROWN
[NAME] | VIOLET | GREEN | BLUE |  |  |  |  |  |  | GREY |  |  | In this example the previously entered data tracks the original list. The new colors are blank because no manual data has been entered.
RICHARD | ORANGE | PURPLE | PINK | RED | YELLOW |  |  |  |  | PURPLE | 16
 |  |  |  |  |  |  |  |  |  | BLACK | 32
 |  |  |  |  |  |  |  |  |  | YELLOW | 64
 |  |  |  |  |  |  |  |  |  | ORANGE | 128
 |  |  |  |  |  |  |  |  |  | PINK | 256
 |  |  |  |  |  |  |  |  |  | VIOLET | 512
DESIRED RESULT EXAMPLE #2
DATASET |  |  |  |  |  |  |  |  |  | DYNMAIC LIST | MANUAL DATA
NAMES | COLOR1 | COLOR2 | COLOR3 | COLOR4 | COLOR5 |  |  |  |  | UNIQUE LIST | COLOR CODE
[NAME] | GREEN | GREY | BLUE | BROWN |  |  |  |  |  |  | 4
RODNEY | PURPLE | RED | BLACK | ORANGE |  |  |  |  |  | GREY
NICK | GREEN | BLUE | RED | YELLOW | ORANGE |  |  |  |  | BLUE | 8
[NAME] | RED | ORANGE | PINK | RED |  |  |  |  |  | BROWN |  |  | this example is the same as above, but the order re-arranged to illustrate my problem another way. Once again the two cells are blank because no data has been entered.
[NAME] | VIOLET | GREEN | BLUE |  |  |  |  |  |  | PURPLE | 16
RICHARD | ORANGE | PURPLE | PINK | RED | YELLOW |  |  |  |  | RED | 2
 |  |  |  |  |  |  |  |  |  | BLACK | 32
 |  |  |  |  |  |  |  |  |  | ORANGE | 128
 |  |  |  |  |  |  |  |  |  | YELLOW | 64
 |  |  |  |  |  |  |  |  |  | PINK | 256
 |  |  |  |  |  |  |  |  |  | VIOLET | 512