Forum Discussion
Segregate the item like family
Below instruments needed to segregate based on the family. please find the attachment.
You may TRANSPOSE as an array (Ctrl+Shift+End) or put your families horizontally, in attached file it's in F24.
In F25
=IFERROR( INDEX( $B$3:$B$39, AGGREGATE(15,6, 1/ISNUMBER( SEARCH( F$24, $B$3:$B$39) )*( ROW($B$3:$B$39) - ROW($B$2) ), ROW()- ROW($F$24)) ), "" )drag it to the right and when entire row down till empty cells appears.
You may TRANSPOSE as an array (Ctrl+Shift+End) or put your families horizontally, in attached file it's in F24.
In F25
=IFERROR( INDEX( $B$3:$B$39, AGGREGATE(15,6, 1/ISNUMBER( SEARCH( F$24, $B$3:$B$39) )*( ROW($B$3:$B$39) - ROW($B$2) ), ROW()- ROW($F$24)) ), "" )drag it to the right and when entire row down till empty cells appears.