The formula between the brackets is made up of: Using the formula =ADDRESS(1,1,4,TRUE) I get the value A1. For example, row 1 column 1 is cell A1 – row 255 column 10 is J255. The address formula gives a cell reference in text given row and column numbers. It is a simple formula, but the key to solving our issue here. For example =ROW(A1) would give the answer 1, =ROW(G84) would give the answer 84. This formula returns the row number of a cell reference. What follows may seem long winded, but it was easy and quick to piece together using different formulas. Excel’s column letters followed the same sequence that the user wanted, so if I could use this, then that would give the user what they wanted. It was an unusual question and in a split second of inspiration (not a common occurrence) I saw the answer in Excel itself. There were too many rows to be filled in so the user was looking for a quicker, less mundane way to populate the cells other than typing in each letter. Once the sequence reached Z, the next letters would be AA, AB and so on. If you type 1 in a cell and drag it down Excel can populate the cells with sequential numbers (2, 3, 4, 5, 6, 7, 8, etc).Ī user needed a list of sequential letters (a, b, c, d, etc). This week I was asked how to auto-fill sequential letters in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |