extract all values in column, excluding immediate duplicates only

[chriswrcg]

I have a list of names in a column. they appear in duplicate groups but the groups can occur more than once. I need a way to list each name from the column in order but exclude immediate duplicates but not other instances of the same name later on. If that makes since. The list on the left would become the list on the right.

Me Me
Me You
Me Them
You Me
You You
You
Them
Them
Them
Me
Me
Me
You

[Limor_OP]

Hi

with a helper in B:
=IF(A1=A2,"",A1)

G1 and down:
=IFERROR(INDEX($A$1:$A$61,AGGREGATE(15,6,ROW($B$1:$B$61)/($B$1:$B$61<>""),ROWS($A$1:A1))),"")

[Fluff13]

Another option.
In E1 & drag down

Please Login or Register  to view this content.

[T.I.]

del.
Reason: the same solution provided above

[chriswrcg]

Hi

with a helper in B:
=IF(A1=A2,"",A1)

G1 and down:
=IFERROR(INDEX($A$1:$A$61,AGGREGATE(15,6,ROW($B$1:$B$61)/($B$1:$B$61<>""),ROWS($A$1:A1))),"")

For some reason the code is not returning the first name on the worksheet I am using it on. I have it set up the same way but it is just ignoring the first name and starting the list with the second name.

[Glenn Kennedy]

This certainly works...

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$61)/($A$1:$A$61<>$A$2:$A$62),ROWS(H$1:H1))),"")

[Limor_OP]

For some reason the code is not returning the first name on the worksheet I am using it on. I have it set up the same way but it is just ignoring the first name and starting the list with the second name.

Dont know why, but you received an integrated solution from Fluff13 and Glenn Kennedy, both should work.

[chriswrcg]

Thanks for all the help guys, as always yall have taught me a lot.

[Fluff13]

Glad to help & thanks for the feedback