how to display multiple children of a parent in excel

L

LATCHALI

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.
 
D

Dave Peterson

Put the common security number on each row associated with that parent.

Then use Data|Filter|Autofilter.
 
Top