Counting of Names ?

Vijay · Feb 27, 2004

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

Norman Harker · Feb 27, 2004

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Vijay · Mar 1, 2004

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

Norman Harker · Mar 1, 2004

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.