I have two columns, Col A. is price and Col B. is time. I want to enter a formula in Col C to calculate price change, when time in Col B crosses 60 seconds (or 1 min.)
Attached excel has values and brief details, which might help understanding what I mean.
Looking forward to some quick replies. Would prefer a formula as i have no knowledge of VBA or Macro.
Thank you very much, in advance.
Please refer to attachment, which has the above table better displayed.
Bookmarks