excel 2002 data filter

  • Thread starter Thread starter Ivanko
  • Start date Start date
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!!!
Click to expand...

You probably need a heading in row 1
 
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
 
Back
Top