Sort List to show 1 of each item

[JamesT1]

Hi Folk

I am looking for a way to take items in a list and show one of each item in another column

The attached sheet show a list of departments, in colum B I am looking to show 1 of each department

hope you can help,,


thanks

[zbor]

For XL 2007:

Click on any cell in A column that contains data

Then: data ->( in sort&Filter) Advanced Filter -> Copy to another location -> Select location in Copy to... -> check box unique records only -> ok

[JamesT1]

Hi zbor

Many thanks for pointing me in the right direction,,,,,,

in excel 2003 its nearly the same

Highlight your list

then: data -> filter -> advanced filter -> copy to another location -> copy to (select where you want the filtered list) and check the Unique Records only box

much appreciated

[zbor]

Thx for writing solution that worked for you and for solving thread.

You could also state excel version in your profile and that would be perfect day