Hi
I have a lomg list of hotel names in column A. Some of the hotel names
occur more than once in the list, so the 500 item list only contains the
names of about 180 different hotels. Is there a function I can use that will
list in column B just the 180 different names,i.e. reduce the list in column
B to just the unique occurences?

Very grateful for any advice.

Chip Pearson has the answer to your question on his web site

http://www.cpearson.com/excel/duplic...tractingUnique


"Chandler" wrote in message
...
Hi
I have a lomg list of hotel names in column A. Some of the hotel names
occur more than once in the list, so the 500 item list only contains the
names of about 180 different hotels. Is there a function I can use that
will
list in column B just the 180 different names,i.e. reduce the list in
column
B to just the unique occurences?

Very grateful for any advice.

Thanks. Very useful

"Rob" wrote:

Chip Pearson has the answer to your question on his web site

http://www.cpearson.com/excel/duplic...tractingUnique


"Chandler" wrote in message
...
Hi
I have a lomg list of hotel names in column A. Some of the hotel names
occur more than once in the list, so the 500 item list only contains the
names of about 180 different hotels. Is there a function I can use that
will
list in column B just the 180 different names,i.e. reduce the list in
column
B to just the unique occurences?

Very grateful for any advice.