View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default 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