Select the range then

Data|Filter|Advanced filter

Select Copy to another location
Check Unique items only
Ignore criteria range
Enter a cell to copy to
Click OK

Mike

"Neil Pearce" wrote:

Dear all,

Column A contains a list of room types inputted by A.N.Other, e.g. classroom
, toilet, staff room etc. Several of the room types are repeated, i.e.
toilet appears several times.

Is there a simple way to copy the different room types without duplication?


Thanking-you in advance,

Neil