Hello
Hoping for some help with this on - I have found and am using the following formula which returns the content of the last entry (left to right) of the row:
=LOOKUP(2,1/(N7:AJ7<>""),N7:AJ7)
I won't claim to understand what this is doing but it works and I have copied and pasted down column AK below the header row which is row 5:
Where I am stuck is that I would like to amend the formula to also return the contents of the corresponding header cell (row 5) which contains a date.
I can concatenate but I'm stuck at pulling the date from row 5 using a formula the can be copied down column AK that will still give the correct results.
Just in case it is relevant, I have a button / macro in place that adds additional columns if needed to the left of Column AK.
The basic layout is
Thanks for looking
Lindsay
Hoping for some help with this on - I have found and am using the following formula which returns the content of the last entry (left to right) of the row:
=LOOKUP(2,1/(N7:AJ7<>""),N7:AJ7)
I won't claim to understand what this is doing but it works and I have copied and pasted down column AK below the header row which is row 5:
Where I am stuck is that I would like to amend the formula to also return the contents of the corresponding header cell (row 5) which contains a date.
I can concatenate but I'm stuck at pulling the date from row 5 using a formula the can be copied down column AK that will still give the correct results.
Just in case it is relevant, I have a button / macro in place that adds additional columns if needed to the left of Column AK.
The basic layout is
Name | 1 Jan 2020 | 2 Feb 2020 | 6 Feb 2020 | Last Entry |
xxxxxxxx | aaaa | bbbbbb | 6 Feb 2020 bbbbbb | |
yyyyyyy | cccccc | 2 Feb 2020 cccccc |
Thanks for looking
Lindsay