I'm having difficulty creating a list that does not include any duplicated value. The list of unique values, needs to be in a different sheet and I need to retain the original list with duplicate values.
Here's' the original list. Col-c is simply identifying if the value ind Col-D is the first occurrence and uses the formula =countif($d$8:$d8,d8)=1 in C8 which is copied down.
c d
TRUE 20030300RGATES
TRUE 20030300LWEISS
TRUE 20030300TWELCH
TRUE 20030300CCHEN
TRUE 20030300EKNUTH
TRUE 20030300JBLOESER
FALSE 20030300LWEISS
FALSE 20030300RGATES
TRUE 20030300SFLETCHER
TRUE 20030300SMCCOVEY
FALSE 20030300TWELCH
I want to end up with the list below in a different sheet.
20030300RGATES
20030300LWEISS
20030300TWELCH
20030300CCHEN
20030300EKNUTH
20030300JBLOESER
20030300SFLETCHER
20030300SMCCOVEY
Thanks for any help.
Bookmarks