SOLVED
Home

Formula Help - It's got me stumped!

%3CLINGO-SUB%20id%3D%22lingo-sub-358349%22%20slang%3D%22en-US%22%3EFormula%20Help%20-%20It's%20got%20me%20stumped!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358349%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20Looking%20for%20a%20formula%20which%20I'm%20sure%20is%20possible%20but%20it's%20got%20me%20stumped.%20I%20have%20a%20table%20that%20I'm%20wanting%20to%20add%20a%20formula%20to%20that%20brings%20back%20the%20date%20in%20the%20table%20header%20based%20on%20the%20last%20populated%20cell.%20I%20have%20added%20a%20picture%20as%20an%20example.%20The%20example%20would%20be%20for%20%22Text%201%22%20row%2C%20based%20on%20the%20last%20cell%20being%20populated%20by%2040%25%20I%20would%20like%20it%20to%20return%20the%20end%20date%20of%2031-08-19%20(hope%20this%20is%20making%20sense).%20For%20%22Text%207%22%20row%2C%20based%20on%20the%20last%20cell%20being%20populated%20by%20100%25%20I%20would%20like%20it%20to%20return%20the%20end%20date%20of%2030-04-19.%20Any%20help%20would%20be%20great.%20Thank%20you%20%3A-)%20Paula%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358349%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358809%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%20-%20It's%20got%20me%20stumped!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358809%22%20slang%3D%22en-US%22%3EYou're%20very%20much%20welcome.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358806%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%20-%20It's%20got%20me%20stumped!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%20Thank%20you%20much%20for%20this%20%3A-)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20worked%20a%20treat.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358372%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%20-%20It's%20got%20me%20stumped!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358372%22%20slang%3D%22en-US%22%3EAssuming%20your%20screen%20shot%20is%20in%20A1%3AK8%2C%20your%20formula%20in%20K2%2C%20copied%20down%20to%20K8%20is%3A%3CBR%20%2F%3E%3DINDEX(A%241%3AJ%241%2C%3CBR%20%2F%3ECOUNTA(A2%3AJ2))%3C%2FLINGO-BODY%3E
Miggymoo2019
New 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
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.