Counting up names

[Cmorgan]

Afternoon,

I don't know if this is possible but.

I have a column (A) which is full of names, some are repeated multiples times - more names get added each week. Is there a way to get excel to create a list of the names with the number of times they appear - without doing a lookup?

Many thanks for any hep you can give.

[MarvinP]

Hi Cmorgan,

This sounds like an easy Pivot Table answer where Count is used.
See attached for simple example.

[stanleydgromjr]

Cmorgan,

It would help if you could post your workbook/worksheet, with the names in column A, and, in an area to the right (two columns not being used) the results you are looking for.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[Fotis1991]

Hi

Even,I believe, that Martin's solution is the best in this case, i give you a formula solution.

IF---COUNTIF----Auto Filter.

In Column B

=IF(COUNTIF(Sheet1!$A3:$A$10;Sheet1!A3)=1;Sheet1!A3;"")

In Column C

=IF(COUNTIF($A$2:$A$10;C2)=0;"";COUNTIF($A$2:$A$10;C2))

Then Auto Filter>>Option>>Non Blanks.

[Cmorgan]

Thanks for this guys, I've tried to use MarvinP's pivot table but had no joy at creating my own. I've tried to use the help guide in Excel but to no avail. I've managed to create the pivot table so it lists all the names in the column but not sure how to create the counting column. Any suggestions please?

[MarvinP]

Hi Cmorgan,

To create a unique column of people names, so you can apply Fotis's formulas, you need to do an advanced filter and check the Unique check box. See http://www.contextures.com/xladvfilter01.html for some pictures.

This is why I like Pivot Tables as they do the Unique Filter for me and then do the count. No formulas needed. No Advanced Filter using Unique!

[FDibbins]

When you create the PT, click in the column and select "count" from the options in that window

[Cmorgan]

Thanks, for this.