The other day I was trying to do some kinda formula that involved needing the column letter. I know, if one types =COLUMN() you will get the column number. BUT WHAT ABOUT THE LETTER? This formula only goes up to column “ZZ,” AKA column "702," but that’s all I needed.
=MID(ADDRESS(ROW(),COLUMN(),4),1,IF(COLUMN()<27,1,2))
No comments:
Post a Comment