In Excel 2007, since you can filter pivot rows by data area results,
you add the row header into a data column as a count item, then filter
everything greater than 1.

I don't know of a way to do this in Excel 2003 and earlier, without
modifying original data. You can add a column to source data to
include a count, such as:

=COUNTIF(A2,$A$2:$A$100)

And copy down. This returns the count of A2 in its column (A2:A100 in
this case, adjust references as needed) so that you can add it to the
row field, select everything except a count of 1, then drag to report
filter (page area).


On Jan 22, 7:11*pm, Hile wrote:
Is there an easy way in pivots to exclude unique records? I only want to see
those that have a one to many relationship with all the rows of data i'm
showing.

I prefer not to filter the data source first as it is over 30K records and I
can't seem to figure out a complex enough formula to flag the record as I
need.

--
Hile