terrydennis
Member
I have a potential block of data say from B1 to AA10.
Currently , there is data in B1 to Z10 with Row 1 containing the date but the data block grows with time.
What would be the formula to determine the contents of the last column of each row i.e the contents of Z2, Z3 , Z4........ Z10 ?
In case you need an example spreadsheet to help in answering this question , how do you insert a spreadsheet into a question on this form ?
Currently , there is data in B1 to Z10 with Row 1 containing the date but the data block grows with time.
What would be the formula to determine the contents of the last column of each row i.e the contents of Z2, Z3 , Z4........ Z10 ?
In case you need an example spreadsheet to help in answering this question , how do you insert a spreadsheet into a question on this form ?