LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
mju mju is offline
external usenet poster
 
Posts: 29
Default Determining Change in a cell Value....

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining if Cell has Formula PosseJohn Excel Programming 3 November 26th 08 09:42 AM
Determining Cell within Range Pablo Excel Programming 1 February 27th 08 02:33 AM
Determining if selection change was the result of ENTER joeeng Excel Programming 3 October 2nd 06 08:04 PM
determining a Commndbar name from a cell davegb Excel Programming 8 January 26th 06 11:00 PM
Determining A Cell If it contain A string value Rob Excel Programming 7 August 26th 05 03:58 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"