software

I need to create a report showing the total list of people and the occurances.

Currently my list looks like the following:

A1
ADAM BROWN
ADAM BROWN
JOHN SMITH

I need a report showing me the name and the total number of occurances e.g.

A1 B1
ADAM BROWN 2
JOHN SMITH 1

Please advise on how this could be done?

I think this is the easiest way:

Select your list
Datagt;Pivot Table
Source: Excel List...Click Next
Range: (already selected)...Click Next
Click the [Layout] button
ROW: Drag the Name field here
(Dbl-click it and set subtotals to None)

DATA: Drag the Name field here
(If it doesn't change to Count of Name: Dbl-click it and set COUNT)

Click [OK]
Select a destination then click [Finish

That will create the kind of list you're looking for.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Rishi Aggarwalquot; wrote:

gt; I need to create a report showing the total list of people and the occurances.
gt;
gt; Currently my list looks like the following:
gt;
gt; A1
gt; ADAM BROWN
gt; ADAM BROWN
gt; JOHN SMITH
gt;
gt; I need a report showing me the name and the total number of occurances e.g.
gt;
gt; A1 B1
gt; ADAM BROWN 2
gt; JOHN SMITH 1
gt;
gt; Please advise on how this could be done?

This is awesome !! Thanks.

quot;Ron Coderrequot; wrote:

gt; I think this is the easiest way:
gt;
gt; Select your list
gt; Datagt;Pivot Table
gt; Source: Excel List...Click Next
gt; Range: (already selected)...Click Next
gt; Click the [Layout] button
gt; ROW: Drag the Name field here
gt; (Dbl-click it and set subtotals to None)
gt;
gt; DATA: Drag the Name field here
gt; (If it doesn't change to Count of Name: Dbl-click it and set COUNT)
gt;
gt; Click [OK]
gt; Select a destination then click [Finish
gt;
gt; That will create the kind of list you're looking for.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Rishi Aggarwalquot; wrote:
gt;
gt; gt; I need to create a report showing the total list of people and the occurances.
gt; gt;
gt; gt; Currently my list looks like the following:
gt; gt;
gt; gt; A1
gt; gt; ADAM BROWN
gt; gt; ADAM BROWN
gt; gt; JOHN SMITH
gt; gt;
gt; gt; I need a report showing me the name and the total number of occurances e.g.
gt; gt;
gt; gt; A1 B1
gt; gt; ADAM BROWN 2
gt; gt; JOHN SMITH 1
gt; gt;
gt; gt; Please advise on how this could be done?

Thanks for the feedback....I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP-Proquot;Rishi Aggarwalquot; wrote:

gt; This is awesome !! Thanks.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; I think this is the easiest way:
gt; gt;
gt; gt; Select your list
gt; gt; Datagt;Pivot Table
gt; gt; Source: Excel List...Click Next
gt; gt; Range: (already selected)...Click Next
gt; gt; Click the [Layout] button
gt; gt; ROW: Drag the Name field here
gt; gt; (Dbl-click it and set subtotals to None)
gt; gt;
gt; gt; DATA: Drag the Name field here
gt; gt; (If it doesn't change to Count of Name: Dbl-click it and set COUNT)
gt; gt;
gt; gt; Click [OK]
gt; gt; Select a destination then click [Finish
gt; gt;
gt; gt; That will create the kind of list you're looking for.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Rishi Aggarwalquot; wrote:
gt; gt;
gt; gt; gt; I need to create a report showing the total list of people and the occurances.
gt; gt; gt;
gt; gt; gt; Currently my list looks like the following:
gt; gt; gt;
gt; gt; gt; A1
gt; gt; gt; ADAM BROWN
gt; gt; gt; ADAM BROWN
gt; gt; gt; JOHN SMITH
gt; gt; gt;
gt; gt; gt; I need a report showing me the name and the total number of occurances e.g.
gt; gt; gt;
gt; gt; gt; A1 B1
gt; gt; gt; ADAM BROWN 2
gt; gt; gt; JOHN SMITH 1
gt; gt; gt;
gt; gt; gt; Please advise on how this could be done?