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)
-
I recently became interested in amateur rocketry when I discovered Richard Nakka ’s Experimental Rocketry Web Site . After studying the site... -
For the beginner, a PERT estimate is a method for estimating the duration of a task by taking pessimistic (P), realistic (R) and optimistic ...
-
An old school buddy recently wrote me, "Nobody has ever died and come back from the dead 3 days later. It is a myth, a fable, a legend-...
No comments:
Post a Comment