ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to display multiple children of a parent in excel (https://www.excelbanter.com/excel-discussion-misc-queries/131820-how-display-multiple-children-parent-excel.html)

LATCHALI

how to display multiple children of a parent in excel
 
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

how to display multiple children of a parent in excel
 
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


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com