In cell 1A value = 100 in cell 2A value = 200 In cell 3A value = 300 ..and so on Difference amount goes into 1B So in this case 1B = 200 (3A-1A)
Without knowing how many entries will be introduced in column A (could be 10 or could be 110 entries)
How can I ask calc to calculate the difference between the last entry in Column A and the first Entry in Column A (1A)
So Basically I just want to subtract the first entry from the last current entry In Column A with out out knowing how many entries there might be.
Thanks for the help