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

Then use Data|Filter|Autofilter.


LATCHALI wrote:

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.

--

Dave Peterson