Count row's with same value in column A.

  • Thread starter Thread starter RedAlert80
  • Start date Start date
R

RedAlert80

I have a worksheet with 2 columns. Column A consist of names of peopl
and column B results of those people.

Those people can have different results. Person A can have 3 result
and person B can have 8 results.

Every result is recorderd in a new row with the name of the person i
column A and the result in column B.

How can i count how many result a person have? The result must come i
column C. There is a formula that have the name COUNT but i cant get i
working.

Somebody have a idea? Please no VB script
 
=COUNTIF(A:A,"Bob")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
RedAlert80 > said:
I have a worksheet with 2 columns. Column A consist of names of people
and column B results of those people.

Those people can have different results. Person A can have 3 results
and person B can have 8 results.

Every result is recorderd in a new row with the name of the person in
column A and the result in column B.

How can i count how many result a person have? The result must come in
column C. There is a formula that have the name COUNT but i cant get it
working.

Somebody have a idea? Please no VB script.
Click to expand...

In C1 put this formula:
=COUNTIF(A:A,A1)
Then copy it down column C as far as you have data in column A.
 
Thanks for the fast reply's, it works. Now i want to filter te list. S
it wil only show unique persons. If a person with the name Paul have 1
results it will show only 1 record insteed of 10 records.

There is a option under the menu Data there is a option to filte
unique records. But that doesn't work, i think because of th
formula's.

How can i filter the list or make a formula that puts only uniqu
records in a new worksheet
 
Why don't you just do a pivot table on column A. This will make you
unique list with a count
 
2 steps, without VB code;
Step1:
Assume Column Headers starting on Row 5 (first name on row 6) - Click on one
of your named people (ColA) Click Data, Filter.. Advanced -Complete as
follows: Select Copy to another location; in ListRange Box enter
$A5:A$100(or to bottom of your current list);
Copy to - enter "C5" (w/o quotes) - last click Unique records Only; then OK
This will list out in C6 downward your unique names.
Step2:
Go to cell D6 and enter: =COUNTIF($A$6:$A$100,C2) and copy down only as
far as you have names in Column C.
Save the File.

After updating Col A or B you will have to Erase(delete) the content of Col
C and perform step 1 again; No need in erasing Col D, just leave it
as-is - you might however have to extend it further downward if later more
columns appear in Col C.

My take of doing it For What It's Worth..
 
Back
Top