Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to use Auto Filter ? | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2002/2003 Advanced Filter | Setting up and Configuration of Excel | |||
Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2002 - Is it possible to use Data,Filter,Autofilter as X-Axi | Charts and Charting in Excel |