Working from the inside out, the first step is to construct an address that contains the correct column reference. For reference, the formula in C5 is: =SUBSTITUTE(ADDRESS(1,B5,4),"1","") One way to solve this problem is to construct a valid address with the number and extract just the column from the address. The challenge is that Excel can handle over 16,000 columns, so the number of letter combinations is large. For example, the number 1 should return "A", the number 2 should return "B", the number 26 should return "Z", etc. In this example, the goal is to convert an ordinary number into a column reference expressed in letters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |