how to display multiple children of a parent in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in an excel sheet, the parent having a common security number, he is having
multiple child - if we are typing the common security number, how to display
all the related records for that common security number.
 
Put the common security number on each row associated with that parent.

Then use Data|Filter|Autofilter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Parent to Child Data 1
group imported xml data according to keys 2
how to handle children of parents in contacts table 2
Default In-Cell Dropdown to a specific Index Value? 1
you will be a god if you know how.... 9
Displaying records that have one of two fields equal to Master Field 3
Finding loops in parent/child relationships 3
Merge rows from 2 XLS files using a common key field. 1

Back
Top