Showing posts with label formula. Show all posts
Showing posts with label formula. Show all posts

Thursday, August 15, 2013

Excel Formulas for Finding Column Letters and Numbers

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
- No comments:
Labels: ,
Subscribe to: Posts (Atom)

Paychecks: an Exchange of Value for Value

Having managed and supervised people for many years now, it is evident to me that the concept of "value for value" is not clearly ...

  • The Value of PERT Estimating
    For the beginner, a PERT estimate is a method for estimating the duration of a task by taking pessimistic (P), realistic (R) and optimistic ...
  • Excel Pivot Tables
    Years ago, a friend introduced me to Microsoft Excel pivot tables. This is one of the most powerful and easy-to-use features of Excel, yet t...
  • Building a Wooden Gate
    I recently needed to build a wooden gate. After reading many websites and watching scores of videos, I realized that many people use the tec...