excel 2002 data filter

[Ivanko]

hello
this is the case

if i have in column A data like this:

http://www.abc.com
http://www.cba.com
http://www.abc.com

ok.
When i press select complete column A and then select DATA - FILTER -
ADVANCE FILTER - UNIQUE RECORDS ONLY i get folowing result:

http://www.cba.com

this is not what i want. I want to get folowing result:

http://www.abc.com
http://www.cba.com

u see what i meen? Can u help please and thank you very much!!!

 

[CurlyDave]

hello
this is the case

if i have in column A data like this:

http://www.abc.com               http://www.cba.com                               http://www.abc.com               

ok.
When i press select complete column A and then select DATA - FILTER -
ADVANCE FILTER - UNIQUE RECORDS ONLY i get folowing result:

http://www.cba.com

this is not what i want. I want to get folowing result:

http://www.abc.com               http://www.cba.com

u see what i meen? Can u help please and thank you very much!!!

You probably need a heading in row 1

 

[Gord Dibben]

Your sample data gives the results you want on my Excel 2003.

Do you have any extra spaces in one of the cells?

In an adjacent column enter =LEN(cellref) and copy down.

Should be 18 for each.


Gord Dibben MS Excel MVP