I am entering names of clients as we enrolled them in our program. Is it
possible to have a formula in a column next to the column where I enter the
names, so it will automatically show the number. I would like to be able to
see how many clients we have enrolled. Besides I will use the total number
to another worksheet as a summary.

Example is if I use column B from row 1 down for entering clients' name, I
would like to use column A to number the client as I enter it. Instead of me
numbering column A manually, I would like column A (from row 1 down) to have
formula that number will automatically show as I enter names in column B.

Please help if this is possible.