I'm trying to reference the bottom-most non-blank cell in a column (or a range of cells). Any ideas?
Picture this: 52 rows for 52 weeks. I enter data into the corresponding row once a week. I need to automatically reference the latest data entered into certain columns spanning the week's (row) information. I need to reference the lowest cell in a column that has data in it.