Pivot Tables - Displaying Data automatically

[Scott]

I have a new computer and previously I was able to use
Pivot tables as a shortcut to highlight a list of say 500
items and display the unique items in a pivot table.
However when I try to do that now it doesn't display the
items, it only show the dropdown with the unique items
checked or unchecked and therefore I cannot highlight the
unique items to create my unique items list. Does anyone
know if there is an option that is preventing me from
doing this or any other way to create a unique items list
from a larger list. Thank you very much.

 

[Debra Dalgleish]

If you create a pivot table with a field in the row area, and the same
field in the data area (as Count of [field]) it would create a list of
unique items in the database.

Or, you could use an Advanced Filter to extract a list of unique items.
There are instructions here:

http://www.contextures.com/xladvfilter01.html