Get a pivot table to ignore data
 

For example I have 2 columns of data. One column has names and the other a
score. A name can appear many times but I only want the pivot table to show
and count the instances where a certain score was achieved. So if someone
has passed they do not show on the pivot table but if they failed it will
give the count of fails and the score for each.

Robert 111 suggested a sumproduct function but I don't see how this would
help.

Get a pivot table to ignore data
 

Add another column to the source data, and calculate if the score is a
pass or a fail. For example:

=IF(B2=$E$1,"Pass","Fail")

Where scores are in column B, and cell E1 contains the minimum score
required to pass.

Add the new field to the pivot table's page area, and choose Pass from
its dropdown list.

Neostand wrote:
For example I have 2 columns of data. One column has names and the other a
score. A name can appear many times but I only want the pivot table to show
and count the instances where a certain score was achieved. So if someone
has passed they do not show on the pivot table but if they failed it will
give the count of fails and the score for each.

Robert 111 suggested a sumproduct function but I don't see how this would
help.





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html