• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Information from a block of data

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 ?
 
Back
Top