TEXTJOIN only specific words
Hi
I am making a excel sheet where cell I27 are counting spesific products from C63:C65 and this is working perfectly. But I have problems getting cell L27 a text string of spesific word from cell C63:C65.
Ex: L27 are only looking for "apple" and "banana". C63=Apple C64= House. Then L27 should contain "Apple" only. I have this formula but it only adds everything: =IF(ISTEXT(C63),CONCATENATE(C63," ",C64," ",C65),"")
Let's say yiur "allowed list" (banana and apple) is written in F63:F6
Then in L27 try:
Formula:
Please Login or Register to view this content.
PS. I don't have handy new excel at the moment, so the above answer does not use TEXTJOIN function, which probably would produce more compact formula
Last edited by Kaper; 02-06-2017 at 02:33 PM.
Best Regards,
Kaper
Thank you Kaper. My apologies if I ask stupid but where do I write down my spesific products, eks; "apple" and "banana" in the formula? C64:C65 is a list where i put all my products but the cell L27 is only allowed to show a text string with a specific range of products, in this case "apple" and "banana".
My suggestion was to write your "allowed list" into cells: F63 and F64, but you could write the list directly into formula like:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks