filtering unique items from a list

I have a long,long list in which there are repeated items, how can i filter out a list of unique items. Also the items are all text.

Thank you

[Aladin Akyurek]

On 2002-03-07 07:06, Anonymous wrote:
I have a long,long list in which there are repeated items, how can i filter out a list of unique items. Also the items are all text.

Thank you

Use Advanced Filter, where you check Copy to another location, fill in a cell location for Copy to, and check Unique records only.

I tried that, it gives me an error message :

'You can copy only filtered data to the active sheet.'

any other ideas?
thanks

[Aladin Akyurek]

On 2002-03-07 07:26, Anonymous wrote:
I tried that, it gives me an error message :

'You can copy only filtered data to the active sheet.'

any other ideas?
thanks

Do it first on the active sheet and then move the result to the desired sheet.

Excellent!

Thank you very much

Aditya

[Mark W.]

On 2002-03-07 07:26, Anonymous wrote:
I tried that, it gives me an error message :

'You can copy only filtered data to the active sheet.'

any other ideas?
thanks

If you use the Macro Recorder you can modify the code to Extract to another sheet.