Please help me with Pivot Table!

[fenisol3]

Hello all,

I am trying to create a pivot table. My excel file has
names of different people and each person has social
security #, date of birth, nationality, religion, race and
so on. I want to be able to select a person's name and get
information about him or her. Please help me if you know
how to do this. Thank you very much.

 

[Frank Kabel]

Hi
this does not sound like a pivot table. You may have a look at
Autofilter. See
http://www.contextures.com/xlautofilter01.html
for more details

 

[fkrueger]

You might try the =DGET function. It's useful for extracting a a recor
from a file or list that is unique. Duplicate records will result i
an error

 

[Ken Wright]

If you are looking to be able to filter on a single person and see the detail
for that person then use Data / Filter / Autofilter

If you are looking to do various statistics on the data, then a Pivot Table will
do what you need - Horses for courses, and each to their own