I am making a spreadsheet for share price data. I have a template that will accept data for the next three months. I need a way to tell excel to use the latest data entered in a certain column to compare with the previous data entered before it and the first data in the line.
For example:
IN...