Formula to return the column letter for any cell.
=SUBSTITUTE(ADDRESS(1,COLUMN(E3),4),"1","")
This formula will produce the result: E
Formula to convert a column letter into the column number:
=COLUMN(INDIRECT(CONCATENATE("E","1")))
This formula will produce the result: 5
Subscribe to:
Post Comments (Atom)
-
For the beginner, a PERT estimate is a method for estimating the duration of a task by taking pessimistic (P), realistic (R) and optimistic ...
-
I recently became interested in amateur rocketry when I discovered Richard Nakka ’s Experimental Rocketry Web Site . After studying the site... -
Morning came early and Sten-Åke, his son Jonas, and his brother Hans Herbertsson (who everyone calls “Hesse”) came to pick me up at Hilmersg...
No comments:
Post a Comment