SteveOranjin
Board Regular
- Joined
- Dec 18, 2017
- Messages
- 170
Hello,
I've got a simple count formula that I use as a part of a worksheet I use for work. One of the formulas I have in it is designed to count the number of rows populated in column A. But if I delete a column, and I often times need to, the cell reference goes to null. My question is, is there a way to reference the first row of a sheet - so it is effectively referencing that first row - A - absolutely, even if I should delete A and a new "A" column should take the place of the old one?
Steve
I've got a simple count formula that I use as a part of a worksheet I use for work. One of the formulas I have in it is designed to count the number of rows populated in column A. But if I delete a column, and I often times need to, the cell reference goes to null. My question is, is there a way to reference the first row of a sheet - so it is effectively referencing that first row - A - absolutely, even if I should delete A and a new "A" column should take the place of the old one?
Steve