List?

[Neil Pearce]

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

 

[Jarek Kujawa]

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

 

[Mike H]

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