• 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.

Months

F

fjones

New Member
I have a spreadhsheet that we track hours month after month and I would like a formula that returns only the data that has been entered in the most recent cell in a column. For example, I want only the current month's data to be reflected in the total.
 
Formula to get last text string from a column:

=INDEX(A:A,MATCH("zzz",A:A))


To get last number:

=INDEX(A:A,MATCH(9E99,A:A))


Formula to get last "anything" (be it text or number) from a column:

=INDEX(A:A,MAX(MATCH(9E99,A:A),MATCH("zzz",A:A)))
 
You must log in or register to reply here.
Back
Top