[hellparadiso]

Hello,

I am trying to create a pivot table in Excel 2003 that displays donor activity for a non-profit organization. We have a relatively short contact list, and only a handful of them have supplied us with email addresses.

I need to set this up so that I can easily display only those who have provided email addresses. Is there a formula I can use in the pivot table so that it will not display cells with no value in them?

Thanks!

[Aj_old]

Hello
it's possible, but why do you wanna do this using pivot table, you ca do such just using Auto filter option!
but if you need it be done using pivot table please post a sample workbook

[hellparadiso]

In the old-fashioned words of my youth:

Duh.

Auto-filter it is. Thanks for the thump on the forehead.

[Aj_old]

You are welcome!
If the problem is solved please mark the thread as solved using thread tools!