View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default finding cells with data within a row...

COUNT will report the number of cell in a range with numbers
COUNTA will report the number of non-blank cell sin a range

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Richard Walker" wrote in message
...
In a given row, I may have data in one or more of 12 columns. Is there a
way, with a formula, that I can determine which cells in that row contain
data? Or, alternately, starting at a given column, is there a formula
that
can determine the first cell that contains data?