Hi all!
Hope everyone is having an excellent 2020 so far!
I have a fairly simple spreadsheet where each column from E to BF represents a week with the week name in row 1. For each row, I am trying to detect the last column that includes text, and when the last instance is detected, I want the formula to display the text from row 1 of each respective column. In other words, I am trying to show the last week where there is text in a column.
There are often blanks in each row, so for instance, there may be text in column H, but then nothing in I or J, then text in K again, and so on. If there was no more text in any columns after K, then I'd want the contents of K1 to be the result of my formula.
Looking to add my formula to D2 and down.
Any help would be greatly appreciated!
Hope everyone is having an excellent 2020 so far!
I have a fairly simple spreadsheet where each column from E to BF represents a week with the week name in row 1. For each row, I am trying to detect the last column that includes text, and when the last instance is detected, I want the formula to display the text from row 1 of each respective column. In other words, I am trying to show the last week where there is text in a column.
There are often blanks in each row, so for instance, there may be text in column H, but then nothing in I or J, then text in K again, and so on. If there was no more text in any columns after K, then I'd want the contents of K1 to be the result of my formula.
Looking to add my formula to D2 and down.
Any help would be greatly appreciated!
