Size of Row
A quick way of doing this is to add an if satement in column B
=if(a1 < "",1)
copy this formular all the way down column b
Then add a sum statement to the botom of column b. the sum will contain the
total number of non blank rows
" wrote:
Hi,
Does anyone know of a quick way of working out how much data a row
contains?
I was hoping to be able to make an estimate of how big a workbook
could get.
Thanks,
Mark
|