Find last column number and convert to letter in Excel
In Excel, to find the last column number in the range and then convert the number to column letter, you can use the MIN, COLUMN and COLUMNS functions and nest the formula in the SUBSTITUTE and ADDRESS functions.