SOLVED

Formula Help - It's got me stumped!

Copper Contributor

Hi everyone, Looking for a formula which I'm sure is possible but it's got me stumped. I have a table that I'm wanting to add a formula to that brings back the date in the table header based on the last populated cell. I have added a picture as an example. The example would be for "Text 1" row, based on the last cell being populated by 40% I would like it to return the end date of 31-08-19 (hope this is making sense). For "Text 7" row, based on the last cell being populated by 100% I would like it to return the end date of 30-04-19. Any help would be great. Thank you :) Paula

3 Replies
best response confirmed by Miggymoo2019 (Copper Contributor)
Solution
Assuming your screen shot is in A1:K8, your formula in K2, copied down to K8 is:
=INDEX(A$1:J$1,
COUNTA(A2:J2))

@Twifoo  Thank you much for this :)

 

This worked a treat.

You're very much welcome.
1 best response

Accepted Solutions
best response confirmed by Miggymoo2019 (Copper Contributor)
Solution
Assuming your screen shot is in A1:K8, your formula in K2, copied down to K8 is:
=INDEX(A$1:J$1,
COUNTA(A2:J2))

View solution in original post