Exclude Unique Values
I got the formula to work. It was backwards, the range goes first then the
criteria.
=COUNTIF(range, criteria)
=COUNTIF($A$2:$A$100,A2)
--
Hile
"ilia" wrote:
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
|