Hi guys,
I have a set of data that is around a 10000 rows long and it comprises of planned and actual data for production of apples by each base in different countries.
Now I would like to find the differences between the actual and the planned values for all the months I have data for.
The only way I can think of is to insert a new row and introduce formula in the new row to calculate the differences between the actual and planned values.
The problem is that I have 10000 lines of data and obviously I cannot introduce a new row and copy and paste the formula for each of them without going insane!
Can anyone help me on this.
Thanks.
Bookmarks