repeated list to single item list

[mckhoa]

Can this be done without VBA, I have a list of names.


i.e.


Names

Bob

Joe

Mike

Bob

Tim

Bob

Mike


I would like to somehow populate those list with no repeated names. So the results would be


List2

Bob

Joe

Mike

Tim


thanks,


mckhoa

 

[Hui]

Mckhoa


You can use the following array formula to assist here:

=IFERROR(INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$1:B1,$A$2:$A$8),0)),"")

I have assume your data is in A1:A8 including the header

Cell B1 is blank

Copy and paste the above into B2

Press Ctrl Shift Enter

Then copy B2 down


You can download a sample using your data here: http://dl.dropbox.com/u/65728154/Unique%20List.xlsx


You could also use an Advanced Filter or Pivot Table to obtain this data

But these don't update automatically as the list changes

 

[mckhoa]

Thank you, you are awesome, made my day.


That is great, I am very appreciative of it. Thank you!!!!!