auto list size

  • Thread starter Thread starter capgunkidd
  • Start date Start date
C

capgunkidd

I have to input a list that includes blank values which must be counted
Currently I must manually calculate the values. I am aware of th
countblank function, but is there a way to have it automatically adjus
for the size of the inputted list? Thank
 
A very simple way would be to use the ROW function. Assuming you have a
header in row 1, if you put the following function in row 18, you'd get the
answer 16

=ROW()-2

It's not dependent on the column and it simply counts the row between the
header and the row where the formula sits. It will also self adjust if you
add rows anywhere before the formula. You'll need to adjust the formula if
you have more than one header row.

Regards

Trevor
 
Back
Top