Counting texts

[computexcel]

From A1 to A1000 my list has names that I add and erase depending on
something else. It is possible to keep update counting of how many names I
have in that mention range ? Which formula ?
THANKS

 

[Gord Dibben]

=COUNTA(A1:A1000) will count all names in that range.

Or do you mean unique names within the range?

See Chip Pearson's site for Counting Distinct Entries In A Range

http://www.cpearson.com/excel/Duplicates.aspx

Scroll down about 75% of page.


Gord Dibben MS Excel MVP

 

[computexcel]

No, I meant all names.
Yes, this is the formula I needed.
Thanks for the answer and for the website.