Assuming Column A is the name column and Column B is the tally column, enter
the following in the first cell of the tally column:
=If(A1="","","1")
Drag this formula down as far as you want. HTH Otto
"WendyM" wrote in message
...
I am trying to figure out how I can use Excel formula or function to do the
following:
When the name column is valued, it will automatically populate "1" in the
tally column.