Formula to count names row by row

Ian Bell
Ian Bell used Ask the Experts™
on
Hi,
I would like a formula to count names progressively on a row by row basis.
Please see attachment for example
Many thanks
Ian
name-totals.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try

=COUNTIF(A2:$A$2,A2)

Open in new window

and fill down

Regards
name-totalsV1.xlsx
Ian Bellretired

Author

Commented:
Thanks Rgonzo,
That seems simple enough and works a treat
Ian

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial