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.
5 Replies
That could be like
with
=FILTER($B$3:$B$39, ISNUMBER( SEARCH(F$13, $B$3:$B$39) ) )if I am trying to create the transpose it comes like .
could you please guide me?How to proceed.
On which Excel you are? Above works on 365, otherwise it shall be something different.
