Tables

[Frankie needs HELP]

If you have a column of names (some names are the same) how do you produce a seperate table that produces a column with the names (without repetition) and then a second column showing the results of how often those names occur?

[lenze]

You can use advanced filter, unique records only option , filter to new location for to produce a list of unique names. Then use COUNTIF to count each name in the first list.

[Mark W.]

Create a PivotTable like the one show below...

*

Count of Name
Name	Total
Curly	1
Larry	3
Moe	2
Grand Total	6

*

[ This Message was edited by: Mark W. on 2002-04-05 07:30 ]

[Frankie needs HELP]

Thanks Ienez but I can't seem to get the COUNTIF to work.

Mark W. I did this before but I don't want a grand total, can I get rid of that?

[Mark W.]

On 2002-04-05 07:37, Frankie needs HELP wrote:

Mark W. I did this before but I don't want a grand total, can I get rid of that?

Right-click the PivotTable, choose Options... from the popup menu, and uncheck "Grand totals for columns".

[Frankie needs HELP]

Thank you, thank you, thank you.

I've got both ways working now.