Sorry it does not work
THe column has a formula sitting in it so that there is nothing displayed if
what its pulling from is blank.
Need something to ignore the formula in each cell unless there is output
printed. and hte output is text.
Sean Timmons wrote:
=counta(column)-countblank(column)
I hve been fighting with this for the last week or so. I have a column which
has the potential to show 100 items. it is a basically filled in with a
[quoted text clipped - 4 lines]
Can I get help on how to make it so it ignores the cells with a formula
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1