filtering unique items from a list

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.