Getting unique values (text) from a list

[darh78]

Hi everybody, this is my first post (after the self presentation).


I'm working on a little modification to adapt the Issue's Tracker template (from chandoo's page) to my current project. I want to create a table (in another worksheet) where I can have the names of the team members that have an open issue (from the Issue_log), however, on source we can haver a name repeated few times (one per issue assigned to a member); on that sense i would like to create that table with only one cell per name (unique values).


Here an example of what I want:


Source data:


Jhon

Tim

Barry

Jhon

Jhon

Mike

Mike

Tim


The table I want is:


Barry

Jhon

Mike

Tim


Does anyone can support me with this? Which formula can I use?


Thanks a lot in advance.


Best regards.

 

[Hui]

Darh

Try using the Google Search at the top of each page

you will find lots of useful links


Specifically for your query try


http://chandoo.org/wp/2006/09/04/how-to-get-unique-items-using-excel/


and


http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/

 

[darh78]

Hui Thanks for the links. I tried to do it and it works, but my list increases (Issue tracker) every day; I did it with the VLOOKUP formula but I get the error "#N/A" because the last number in the order column is empty ("").


I think with a macro could be easier but I do not know how to do it.


Thanks anyway.


Best regards.