Hi all,

I am looking for a formula that will only list the first instance of a name, so for instance i have a list of names like below in Column A, what i want in in Column C is a formula to only list the first instances of the names, so with the below it would only list Jeff, Gary, Angela and Claire, is this even possible in a formula?

Jeff
Jeff
Jeff
Gary
Gary
Jeff
Gary
Angela
Angela
Gary
Claire
Claire
Jeff
Claire

Many thanks all