i have an excel sheet with data in several columns and hundreds of rows that
i am calculating a subtotal for when i filter the data. i want the subtotal
formula as the top row of the spreadsheet so that when the filter is applied
the change in results is visible. i will be adding rows to the bottom of the
spreadsheet and want to define a dynamic range for the column so that i do
not have to change the subtotal formula range every time a new group of rows
is added, but i keep getting circular reference errors when doing this using
the offset formula to name the group of cells. is there a way to define a
name for the last cell in a column that has data in it that would not create
a circular reference?