excel 2002 data filter
 

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

excel 2002 data filter
 

On Feb 14, 2:10*am, 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!!!

You probably need a heading in row 1

excel 2002 data filter
 

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