Forum Discussion
Formula for returning words that fall under a specific class
Dear,
I am in search of a formula that can help me achieve the following:
I have 2 colums, the first one contains classes, the second one contains items. My goal is to give all the items ...
Andreas,
=INDEX(DATA!C:C,AGGREGATE(15,6,ROW(DATA!$C$6:$C$14)/(DATA!$B$6:$B$14=$B$2),ROWS(B$6:B6)))
Yes, even better - forgot about small in aggregate every time