I have a variable-length list of letters in a column in the Excel
sheet. Sometimes the last element of the list is of interest to me for
calculations, that is, the largest numbered cell that is not empty. I
can't simply reference the cell because the list is variable and will
change many, many times in the future.
I am wondering if there is a way to just grab the letters from the
last column? I thought I had a pretty clever solution for this - I'd
concatenate the entire list (the list can't be more than 256 elements,
so I would concat, for example, A1:A256) and then take that text
string and use "RIGHT" to grab the rightmost characters. Every element
of the list is two letters so that'd be easy.
However I was dismayed to find that concat cannot handle cell
references of the form A1:A256. Since this text is going to be
embedded in much larger formulae, explicitly writing out
A1&A2&A3&A4&...&A256 is suboptimal.
Any suggestions? Thanks in davance.