make a cell automatically populate with "1" when specified cell va

W

WendyM

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.
 
O

Otto Moehrbach

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
 
Top