go to the menu for
<data<filter<advanced filter<into another location thick "unique records
only"

--
Greetings from New Zealand

"mju" wrote in message
...
Please i need some Help...

Number (Col A) Start (Col B) End (Col C)
Tp1203 01/20/2009 02/01/2009
Tp1203 01/20/2009 02/01/2009
Tp1203 01/20/2009 02/01/2009
Sb507 05/20/2009 06/10/2009
Sd702 07/08/2010 08/20/2010
Tp1203 01/20/2009 02/01/2009
Tp5203 01/10/2010 01/30/2010
Sb507 05/20/2009 06/10/2009
Sb507 05/20/2009 06/10/2009


This is what I want to have as my final result

Tp1203 01/20/2009 02/01/2009
Sb507 05/20/2009 06/10/2009
Sd702 07/08/2010 08/20/2010
Tp5203 01/10/2010 01/30/2010

How do I check the values in each cell in column A. Whenever the value
changes, it should give me the number, start and end. It should do nothing
if
it is same. I just want the number , start and end repeated once. Values
should also be returned if is only one one number, start and cancel.