Prev: Updating Pivot Tables Dynamically
Next: VBA - Opening afile, copying the contents
From: nir020 on 10 Feb 2010 11:08
is it possible to create a formula so it adjust automically to number of row
or columns in a range, for example if there were values in the range C1 to C5
my countif formula would automatically adjust to countif(c1:c5) and if there
values in cells c1 to c1000 the formula would adjust to (c1:c1000)

Thanks
 | 
Pages: 1
Prev: Updating Pivot Tables Dynamically
Next: VBA - Opening afile, copying the contents