View Single Post
  #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.