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

On Sat, 14 Feb 2009 01:10:01 -0800, Ivanko
wrote:

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!!!