I am new to complex formulas and would appreciate some help. I am importing data from another application. I have a series of rows and columns containing data. Not all cells contain data but the last cell with data represents the sum of the data in the cells on the same row to the left of this cell.
I am wanting to have this total (last cell containing data) to be put into a new cell called ( in a new column called "total" and the data in last cell to be deleted. Basically, I need to recognise the last cell to the left of the column called "total" that has a data value and get this data in the cell containing the formula.
Thanks for your help
I am wanting to have this total (last cell containing data) to be put into a new cell called ( in a new column called "total" and the data in last cell to be deleted. Basically, I need to recognise the last cell to the left of the column called "total" that has a data value and get this data in the cell containing the formula.
Thanks for your help