Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining if Cell has Formula | Excel Programming | |||
Determining Cell within Range | Excel Programming | |||
Determining if selection change was the result of ENTER | Excel Programming | |||
determining a Commndbar name from a cell | Excel Programming | |||
Determining A Cell If it contain A string value | Excel Programming |