excel formula to to record previous value of dde linked cells

This project received 3 bids from talented freelancers with an average bid price of ₹750 INR / hour.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

We want a formula to continuously record the previous value of dde linked cells (real time feed).

say for example we have dde cell is a1 and the current value is 50 we want a formula in b1 that will record the previous value of a1.

now when the price changed to 45 b1 will hold the previous value that is 50 again when the price of a1 changes to 42 b1 will now hold the value 45 and so on...

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online