LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carl
 
Posts: n/a
Default Recording the first change in the value of a cell

I have a spread sheet that looks like so before the start of the trading day:

ColA ColB ColC
ABC 4/7/2005

ColB tracks the trade time of stock ABC.

When ABC does it's first trade, the spreadsheet looks like so:

ColA ColB ColC
ABC 9:32:28AM

I would like to place a formula in ColC or find a way to record the time of
the first trade.

Is it possible ?

Thank you in advance.




 
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
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM
change a function in a workbook without changing every cell sir lancelot Excel Worksheet Functions 3 March 10th 05 11:29 PM
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM
Change value in cell every n seconds Stan Altshuller Excel Worksheet Functions 1 December 23rd 04 07:51 PM
change operating cells dynamically according to the value of a fixed cell Zuohong Excel Worksheet Functions 2 November 17th 04 08:11 AM


All times are GMT +1. The time now is 07:09 PM.

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"