Excellent content. I built the nested "substitute" statements (around 11 minutes in) into my word list formula to avoid creating a new text string. Doing it that way, there is no need for minutes 12-19 in the video. For the final piece. I suggest manually build your list of exclusion words, as instructed. Then add a column to your unique word list for a vlookup ]example: =IFERROR(IF(LEN(VLOOKUP(i5,O:O,1,FALSE))>0,""),i5)] to replace exclusion words with "". Add a column to repeat the count [=IF(K5="","",J5)] and manually sort the list.
![ร้อยพ่อพันแม่ - WanMai [Official MV]](http://i.ytimg.com/vi/XY2pNYASEbg/mqdefault.jpg)
![PASULOL รามเกียรติ์ ตอนที่ 4 นนทกพบรัก [Ramakien Ep.4: Nonthok in love]](http://i.ytimg.com/vi/tMUQgmZzf_A/mqdefault.jpg)
Excellent content. I built the nested "substitute" statements (around 11 minutes in) into my word list formula to avoid creating a new text string. Doing it that way, there is no need for minutes 12-19 in the video. For the final piece. I suggest manually build your list of exclusion words, as instructed. Then add a column to your unique word list for a vlookup ]example: =IFERROR(IF(LEN(VLOOKUP(i5,O:O,1,FALSE))>0,""),i5)] to replace exclusion words with "". Add a column to repeat the count [=IF(K5="","",J5)] and manually sort the list.
Great explainer!
Yes wants to see next video
Thanks in a million. Great content. Awesome imagination. Grade: A++💥
Awesome! Great effort. Thank you.
this is awesome content thank you so much
Glad you enjoyed it!
Awesome bro I would like to see the filter function and could you also share the copy file for this video as well
Great video - would love to see how you use this with the let function and an array of stop words
Nice and good job. Put excel practiced files in the description.
Great content
Hello sir,
Awesome video sir.Would like to know let function more broadly.
And , also the word stop and filter procedures too.
Interested
Great content