Counting of Names ?

  • Thread starter Thread starter Vijay
  • Start date Start date
V

Vijay

I have some names in some cells like " Abraham" " Sathish " etc . I
want the number of occurances of each name Counted ,within a range of
cells and made known at a perticulat cell

Like

Name No of Times
Abraham 110
Sathish 20


Regards
Vijay
 
Hi Vijay!

Put the unique names in a column and use (eg)

=COUNTIF($A$1:$A$25,D1)

If you want a fast way of extracting the list of names see:

Chip Pearson
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks a many for the help .
I have one more requirement
I want to select multiple ranges for the Coountif ? How to doi that ?

like =Countif(Range 1 , Range 2 , Range 3, NAME ) is that possible ?

-Vijay
 
Hi Vijay!

I'm afraid you'll have to use a series of COUNTIF functions. COUNTIF
won't even accept range names of non-contiguous blocks of cells.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Dhanapal
Vittal







Dhanapal

Vittal
Vittal
Vijay
Dhanapal
Vittal
Dhanapal


No of Counts Dhanapal = 3

Why Countif for Dhanapal shows 3 instead of showing 4 ?

Regards
Vijay
 
Hi Vijay!

I copied your data into A1:A17 including empty cells A3:A3 and A11

I then used:

=COUNTIF(A1:A17,"Dhanapal")
It returns 4.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top