Hi everyone,
I want to count number of occurrences of name (Text) in list, the list consist of 230 entries and their is unique names is 83 but most of them are repeated. if i am using countif function then i have to go each time to type the name in inverted commas "Name" which is not possible all the time.
I will give you a small example.
Column A from 1 to 230 has a names and i want formula at B1, the range will be A1 to A230 and the Criteria will be A1 and not "" commas.
The formula should check how many times the name on A1 is repeated until A230, it should give me total in numeric value in formula cell which is B1, remember i don't want to put " " for criteria i want criteria as Cell address A1.
I hope it is clear to understand.
I want to count number of occurrences of name (Text) in list, the list consist of 230 entries and their is unique names is 83 but most of them are repeated. if i am using countif function then i have to go each time to type the name in inverted commas "Name" which is not possible all the time.
I will give you a small example.
Column A from 1 to 230 has a names and i want formula at B1, the range will be A1 to A230 and the Criteria will be A1 and not "" commas.
The formula should check how many times the name on A1 is repeated until A230, it should give me total in numeric value in formula cell which is B1, remember i don't want to put " " for criteria i want criteria as Cell address A1.
I hope it is clear to understand.
