L
Liz G
Hi,
I am trying to find a simple way to count the number of cells in a column
that have text in them, and don't know quite how to do it, other than
entering a '1' in a column next to it and using a simple count function.
Does anyone know of a way to do this? I was trying to form an 'if' function
for the second column, saying 'if A1 is not an empty cell, enter a 1 in B1,
otherwise enter a 0'. Help would be greatly appreciated!
Thanks,
Liz
I am trying to find a simple way to count the number of cells in a column
that have text in them, and don't know quite how to do it, other than
entering a '1' in a column next to it and using a simple count function.
Does anyone know of a way to do this? I was trying to form an 'if' function
for the second column, saying 'if A1 is not an empty cell, enter a 1 in B1,
otherwise enter a 0'. Help would be greatly appreciated!
Thanks,
Liz