List out the name in a range

[mingali]

Hi

i would like to look up a range of names and return a complete listing of those name in another column without duplication.

Eg
Col A has
A1
A2
A1
A4
A5
A4
A3
A6
A5

and i would like to have a complete list
A1
A2
A3
A4
A5
A6

So that i know what is and is not in at first listing.

Any idea which function is to use?

Thanks

[zbor]

Try this:

Unique_values.xls

[mingali]

Thanks Zibor,

however, may i know is there a way to link those list with another column.

eg

col A is cost centre code while col b is cost centre name

Code Name
HR Human Resource
TR Trading

how can i find out whether there is a mismatch in one of those rows for those two columns caused by mispelled, one of the colums is blank, etc?

Thanks

[zbor]

You must define somewhere else all your codes and then check:

=IF(VLOOKUP(A1;defined table;2;FALSE)=B1;"OK";"Check spelling")