Hi,

No reason to go to a lot of work:

1. Select the range and choose Insert, Pivot Table, OK
2. Drag the Name field to the Row Labels area and the Values area.
3. Open the Name filter and choose Value Filters, Greater Than, and enter 1
and click OK.

You can handle expanding ranges by 1. starting with a larger range for the
pivot table, 2. inserting the new names between already existing ones or, 3.
best! define the source as a Table (in 2007 or List in 2003) - Ctrl T, OK.

The above applies to 2007.

In 2003 modify this approach:

1. In B1 enter a title, such as "Greater", and in cell B2 enter a formula
similar to one suggest earlier:
=COUNTIF($A$2:$A$1001,A2)1
2. With this range selected press Ctrl L, OK. This defines this range as a
list.
3. Choose Data, PivotTable and PivotChart Report, Finish.
4. Drag the Name field to the Row area and the Data area, and drag the
Greater field to the left of the Name field in the Row area
5. Open the Greater than drop down and uncheck FALSE. Hide the Greater
column if needed.

No dynamic range name is needed with this solution, so if you are using 2003
or 2007 List/Table is the method of choice for handling expanding ranges.
This opinion regarding the use of List/Table is strictly mine, but I believe
that in time all users will realize their benefits.

--
Cheers,
Shane Devenshire


"h20polo" wrote:

I have a compiled list of all the guests that have attended different events
that we have held in the last couple of years. We are trying to figure out
the loyalty of our guests; identifying those that have attended 2 or more
events. The guest names are in cells A3:A988. How do I come up with a formula
so that the output is the name of anyone who has attended more than one event
(meaning their name appears more than once in column A) and the number of
times they've attended an event, which is updated as more events/names are
added to the list?

Thanks so much.