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)))
Does this produce unique answers?
If for example an items appears twice in the same class, would it then be mentioned twice in the result?
It would be ideal if the word would only be mentioned once.
Thanks a lot already for the formula you gave!
Andreas
Andreas Schryvers wrote:
Does this produce unique answers?
It would be ideal if the word would only be mentioned once.
Well, why didn't say so in your in first posting?
{=INDEX(DATA!C:C,AGGREGATE(15,6,ROW(DATA!$B$6:$B$15)/(IFERROR(MATCH($B$2&DATA!$C$6:$C$15,DATA!$B$6:$B$15&DATA!$C$6:$C$15,0),FALSE)=ROW(DATA!$B$6:$B$15)-5),ROWS(B$6:B6)))}