How and where is the data to be displayed? Very hard to put it in one cell.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Richard Walker" wrote in message
...
Thank you Bernard,

However, I need to know the specific cell that contains data. For
example,
in a row of 12 cells, I need to know not only that two cells contain data,
but that those cells are the third and eighth cells. Is there any good
way
of doing this?

"Bernard Liengme" wrote:

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?