Issue with Textjoin, multiple criteria. IF/AND function
Hi I have attached an example workbook with some example data. My goal is for someone to type in the product and the company category and be given a list of companies that match those two criteria. It needs to be exact. I don't want it to show companies that have the right category but not the product. It needs to be both. I have a working TEXTJOIN function in the example work book that successfully works at listing the companies that match the desired product. But I cannot find a way to integrate an IF(AND or INDEX/MATCH to also include the second required field (Category K15) as an 'AND' function. Let me know if you need more sample data. Any help would be appreciated.
TEXTJOIN function not ignoring blank cells
I am trying to concatenate individual parts of an address into a full address field using the TEXTJOIN function. For example I have Address Number, PreDirection, PreType, StreetName, StreetType, etc and would like them in one field separated by spaces. Some of those fields may be blank so I want those ignored. My understanding is that TEXTJOIN is supposed to make that easy. I would expect that using =TEXTJOIN(" ", TRUE, A2:G2) would accomplish that however I am still getting extra spaces where the empty cells were as seen in the example: 7025 TAYLOR CREEK RD Any idea why this is happening? Thanks in advance !
TextJoin Partial Matches?
Hello, I have a list of usernames that have access to one or more location codes separated by commas. I also have a list of locations with their code on another tab. I have been trying every which way to cross reference the location code by the locations that each username has access to return a TextJoin of which usernames have access to that specific location. Any suggestions?TEXTJOIN formula that incorporates a look up?
Hello All, I have a scenario where for example : I have a list of SKU's for inventory in column A, Column B contains the date the SKU/Product was purchased. Column C lists the Client who purchased the SKU/Product. I need a formula that will look up the SKU and then return the names of the Clients which purchased the item within a set date range. For example between July 1st and July 17th for Product SKU 122145 It should return something like " Brian, Steve, Brian, Brian" So Far I have {=TEXTJOIN(",",1,IF(B:B>=H2,IF(B:B<=I2,C:C,""),""))} Which returns : Brian,Steve,Brian,Brian,Dawson,Dawson,Dawson,Dawson I want it to return only : Brian,Steve,Brian,Brian As a Bonus if it could remove duplicates and return : Brian, Steve that would be even better! Thank you so much!
Can I get TextJoin to not break the Column?
I have a multi-sheet workbook that I am trying to use TextJoin. I have success using the TextJoin function like this =TEXTJOIN(", ",TRUE,Matrix!E2:E3000). I am trying to copy the columns into rows in another sheet. However, click and dragging does not change the column how I thought it would. I used the formula =TEXTJOIN(", ",TRUE,Matrix!E$2:E$3000), and that keeps every thing the same. Can I get it to switch columns only, while keeping my rows the same? I tried using the OFFSET function with no luck.
