Forum Discussion

Miggymoo2019's avatar
Miggymoo2019
Copper Contributor
Feb 28, 2019
Solved

Formula Help - It's got me stumped!

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 l...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Feb 28, 2019
    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's avatar
Twifoo
Silver Contributor
Feb 28, 2019
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))
Miggymoo2019's avatar
Miggymoo2019
Copper Contributor
Mar 01, 2019

Twifoo  Thank you much for this :-)

 

This worked a treat.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 01, 2019
    You're very much welcome.

Resources