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 ...
-
After discussing this topic with a number of leaders from Christian organizations, I have concluded that some leaders of Christian organizat...
-
I awoke Saturday morning at 8:19 AM. The problem here is that Roger and Ulrika had invited me to have coffee and go for a walk at 8AM. Roger...
No comments:
Post a Comment