>>The $ locks that portion. So you can use $A29 to always use column A, but the row will change. Or A$29 to always use row 29, but the column will change. And $A$29 to lock both.
>
>This is great information.
In addition to learning about absolute and relative references, if you're doing anything tricky with Excel you might want to switch to R1C1 notation:
https://bettersolutions.com/excel/formulas/cell-references-a1-r1c1-notation.htm
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up