Providing a solution to both the 365 and 2016(and above) thank you once again
@__Est.her__9 ай бұрын
I was breaking my head trying to do this with a rather large dataset. Thank you!😭😭😭😭😭😭😭❤
@mikewchiasson2 жыл бұрын
Thank you for this. I'm using it to pull together sentences into an initial paragraph to give comments to students on their papers.
@francisguchie1973 Жыл бұрын
Exactly what i needed thank you so much
@ChesterTugwell Жыл бұрын
You’re welcome 😊
@wenjuanjurewicz3057 Жыл бұрын
This is such a life saver - Thank you so much!! This video does exactly what I needed, after my head spins going through so many videos with INDEX MATCH function...
@KalyanKommanapalli3 жыл бұрын
Thanks so much for putting this together. I was exactly looking for this use case and I was struggling for a day when I came across your video after going through so many other ones. Thanks again and appreciate your help. I just subscribed to your channel too!
@LauraLopez-pi4dd2 жыл бұрын
EXACTLY what I needed, concise and simple, thanks!
@paradigmvisions76378 ай бұрын
Thanks! This was awesome. Super clear and simple explanation.
@SimX90003 жыл бұрын
Just what I needed, thank you so much. 365 is so much better.
@kugmogamay Жыл бұрын
This is great! This gives me an idea to eliminate extra data. For this one though it only says to skip blanks, and ignore the same data, I was wondering if there's an option to skip N/A too (the data is not reflected using vlookup, that's why it's N/A for now)
@butterflyGirly7691 Жыл бұрын
Excellent! but I have the data the other way around. Like I have a base table with one record for each row. lookup table has multiple records in cell. How to extract all the records from one cell and display them with a separator in one cell?
@IvanCortinas_ES3 жыл бұрын
Very good example and resolution Chester. More used than it seems. Thank you!!!
@ydee1864 Жыл бұрын
thank you sir Love from Sydney
@milansaram Жыл бұрын
Exactly what I want, thank you so much
@inririwetrust3 жыл бұрын
So much time won!! Thanks a lot!!
@moondropx2 жыл бұрын
Can’t thanks you enough for this!
@septafaustino5697 Жыл бұрын
Thank you very much!
@ShahidulIslam-fy3bz3 ай бұрын
Thank u sir
@ShahidulIslam-fy3bz3 ай бұрын
I could
@louismorris80122 жыл бұрын
Great video!
@ashishshiriskar1233 жыл бұрын
Thanks alot . This will very helpful to us. 😁
@danielgovetti77602 жыл бұрын
Awesome rational
@intellistruction57602 жыл бұрын
This was Excellent, Thank you!. How would I use the same function but instead of having the function return the Titles of books read, the Row numbers would be returned
@loucruz59063 жыл бұрын
thank you ill try this tom
@kevingarala5471 Жыл бұрын
Exactly what I needed, but I have MS office 2013, So can you please explain how this is possible in MS office 2013? As it did not have TEXTJOIN function.
@vv9730 Жыл бұрын
nice work..was searcing for this for a long.... its working for exact match only..how to modify the same to match partial text also..??? its not working if we use "*"&cellref&"*" in "="...
@mjpan893 жыл бұрын
Thank you so much. Is it possible for each book title to be displayed as a new line within the cell? What would the delimiter be?
@kistnaalper55122 жыл бұрын
Maybe a Char(10) could provide the page break you need?
@Rommel-xq1ox2 ай бұрын
Help, I'm making grades right now and I think my formula is right however when I used vlookup there is a comma showing at the end of the word even though there is no commas at the original data. What should I do?
@Lalotaotongpeanutbutter2 жыл бұрын
This works a treat. Is there a faster way to run across 40,000 rows?
@madagary2 ай бұрын
Agreed, id love to know if there is a way to optimize this formula. This formula brings my work computer to its knees when using on large datasets 😅
@Airalf008 ай бұрын
in my case the IF formula doesn't return any value using RANGE instead of single value for condition. is it normal? maybe because i'm in excel 2019?
@ubaidillahmuhammad203 жыл бұрын
loved it
@coco99ca2 жыл бұрын
I was hoping this would have the answer to my problem. Unfortunately, the data in the cells isn't as much as I have. I have some cells with too much data. Sometimes the textjoin formula works and sometimes the cells remains blank. At first I didn't understand the problem, but then I took out about 1/2 the data in a cell and it worked. Is there a way to get textjoin to accept the extra data?
@heshegoldy2 жыл бұрын
i tried this formula in excel 2016 based on your instructions and it doesnt work
@helmyherdian72682 жыл бұрын
what type of office do you use sir??i cant find those formulas (text join and unique)
@jaredthereal2 жыл бұрын
Wanting to use this but my "Value if true" data is in a row of cells and that returns 0s for blank cells instead of ignoring them. Is there any way to ignore cells that have no data?
@mr.legendary94277 ай бұрын
please help when i use emply text string "". my formula stops working. PLEASE HELP
@user-re6im7dm1x Жыл бұрын
Hi.. I am getting #SPILL! error while applying the IF formula. can you please help?
@vv97306 ай бұрын
HOW TO ADD MULTIPLE CONDITIONS IN THIS..???
@SamehRSameh7 ай бұрын
How can i do in excel not Excel 365
@EremitaUrbano2 жыл бұрын
Does anybody know how to do this in SQL by any chance?
@Peter-pf8me3 ай бұрын
How about multiple value has ENG in one cell and then look up to form ENG123456, ENG234567, ENG45678.
@salesleadgenerationservice76862 жыл бұрын
Textjoin function is not available in excel 2016
@magpiecorner40282 жыл бұрын
What if Members are in numeric cells like 152 256 365 459 146 I have date as follows Member Title Read 1254 abc 2369 def 12534 ghi 1258 jkl 1789 mno 1254 xyz 2369 gff 12534 sfd 1258 jkl 1789 iop How to combine value? | want in result 1254 = abc & xyz. Kindly help me with the formula in excel
@ikailashrao3 жыл бұрын
I am working on creating a gantt chart having multiple date dependencies. Could u please advise.
@olgatimofeeva2108 Жыл бұрын
There is no textjoin function
@Rommel-xq1ox2 ай бұрын
Help, I'm making grades right now and I think my formula is right however when I used vlookup there is a comma showing at the end of the word even though there is no commas at the original data. What should I do?