Test for data in a range of cells
=COUNTA(range)
counts the number of cells that are not empty. If you want a true or false
use this
=COUNTA(range)0
"Spike9458" wrote:
Hi all,
I am working on a spreadsheet that is a little over 10000 lines long.
Several columns seem to not have any data, but I am reluctant to just delete
them. What sort of function can I used to see if there is any data in a
given column that will just return the result of true or false, text present
or not present?
Thank-you for your help.
--Jim
|