1James buy apple and pearapple 2Banana and durian for lunchDurian
1James buy appleapple 2Peter sell pearpear 3Banana from japanbanana 4apple keeps the doctor awayapple 5Do you sell durian?Invalid , I'm back again.
Hi MS Community, I have the following worksheet. In the Orders Tab, I need to be able to filter out the "Fruit" from the "Sentence". Sheet1 = Fruits Sheet2 = Orders In Fruits: ... wktay here are 2 options: =LET(a,TEXTJOIN(",",1,IF(ISNUMBER(SEARCH($I$1:...
Hi MS Community, I have the following worksheet. In the Orders Tab, I need to be able to filter out the "Fruit" from the "Sentence". Sheet1 = Fruits Sheet2 = Orders In Fruits: ... wktay here are 2 options: =LET(a,TEXTJOIN(",...
If from the "Fruit" table, can I exclude some rows? For below example, I want to exclude the "chicken" So like "$I$1:$I$3 & $I$5:$I$6"" The reason I can't change the "Fruits" table is becuz it is used for other things. ...
Is it possible to just have only 1 fruit, but have the flexibility to adjust which if necessary? Kind Regards Yes I specifically added the TEXTJOIN to show all the results. You could replace with INDEX( ... ,1) to only take the first but not sure what you mean by...
Hi MS Community, I have the following worksheet. In the Orders Tab, I need to be able to filter out the "Fruit" from the "Sentence". Sheet1 = Fruits Sheet2 = Orders In Fruits: ... here are 2 options: =LET(a,TEXTJOIN(",",1,IF(ISNUMBER(SEARCH($I$1:$I$3,...
2 pear 3 banana 4 chicken 5 orange 6 kiwi Thanks in advance yes but not like that. either create a 'helper table' where you do that or use something like: VSTACK($I$1:$I$3,$I$5:$I$6) CHOOSEROWS($I$3:$I$6,1,2,3,5,6) ...