List?
 

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

List?
 

Excel 2003
(Select the whole area with data)
Filter-Advanced filter-define relevant ranges
then select "Unique only"

List?
 

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