Please help me with Pivot Table!

  • Thread starter Thread starter fenisol3
  • Start date Start date
F

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.
 
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
 
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 :-)
 
Back
Top