Google Sheets - Find Similar Text - How to VLOOKUP, MATCH Inconsistent Text
HTML-код
- Опубликовано: 5 сен 2024
- Learn how to find similar text in Google Sheets using FINDSIMILARTEXT function to MATCH or VLOOKUP inconsistent text data, lie companies, misspells, names etc.
Function Code
github.com/chi...
#find #similar #text
How this function was made
Part 1: ruclips.net/video/cU4Mo2H69z0/видео.html
Part 2: ruclips.net/video/1LjPFX_ObTU/видео.html
I cannot even begin to express how much this is going to help me with a task that I have to carry out 3> times/week. Your videos are so helpful. I really appreciate all of the insights and value that you share so selflessly. Thank you.
Thank you so much for this! Saved my week!
Incredible. Thank you very much from Argentina!
Great stuff 😊 It is crazy that FindSimilarText is not available as default?!?
Great solution! Using it to compare similar values for taxonomies! Thank you! Quick Question: Is there a way to alter the script to pull ALL like values? Not just singular exact matches? For example: Comparing a term like Apple to a list that might contain Apple, Apple Pie, Apple Turnover, Oranges, Bananas. The result in the cell would contain not just Apple, but also display all other words containing Apple. Thank you!!! This could save a taxonomist many many hours!
I have a video on my other channel how I made this function using JavaScript. You can modify the javascript code to fit your needs. You can find the channel in about section.
@@ExcelGoogleSheetsin your Javascript video it doesn't have an example to call multiple values with similar text, do you have an example video?
I needed exactly that like one week ago and couldn't find a go option. That's the reason why I had to manually classify 500 rows of a spreadsheet manually 😥
My excel skills as improved thanks 🙏
:) Thank you! I give enough info....
This is amazing, you always deliver execellent solutions
This video is very interesting. Can I find similar text within a column? For example I wouldn't want a column to contain cells which are quite similar to each other. How can I find the similar ones? The duplicate function misses the point.
Wonderful Tutorial
Just magic. Thanks Harry !
Finally got a notification from yt for your channel!
Awesome!
thanks a lot for the solution. It helps a lot. I just had a doubt How can we change the accuracy level for each word differently?
e.g. lets say we need to find the word America but with 0.3 value and California with 0.5. Is there a way to do so?
This is fantastic and I have been using it for the past 3 days. Today however, it has stopped working. No change to data. I keep getting this error "Internal error executing the custom function.".
What i tried:
-I did about 4500 rows yesterday, today after seeing that error, I deleted the formula across all except one, still no luck.
-I copied the sheet into a new sheet, as others on the internet said this might help.
Please help and thank you for this btw!
I believe I found my issue...I was comparing against an entire column vs ranged. =FINDSIMILARTEXT(H5,'DT Only - KRS'!I:I,$I$1, "position")....I:I vs I1:i500 for example
Hey... hi it really means a lot... the hard work u r doing for us... just wanted something more in script editor....
Could u tell me how i can create 500 folders in once in google drive with the following naming pattern....KC001, KC002, KC003... KC300... PLEASE MAKE A VIDEO ON THAT OR SHARE THE CODE WITH ME...
Thanks Always for your effort
Great. Thank you so much.
Amazing thank you!
I have problems with below error:
TypeError: phraseList.flat is not a function (line 20).
Please let me know how to solve.
Thank you.
Excellent tutorial, as always. Is there a way to send to the printer a range of cells using apps script?
Not without a middle service. You basically have to setup a network access to your printer though the internet and then use apps script to trigger that endpoint.
Trust me! You are truely an awesome Guy!
😀
Awesome
Can i find similar with numbers? or just text?
Legend
why isn't "findsimilartext" a function for me in google sheets?
Instructions how to install the function are in the video.
Am I correct in assuming that others would have to download the script in order to see the correct data output?
I'm not sure what you mean by others. Once you set it all up in your spreadsheet, other users of the same spreadsheet won't need to download and install the script.
@@ExcelGoogleSheets Thank you! That is what i meant!
ArrayFormula(vlookup(C2:C&"*",C2:D,2,FALSE))
simple, no script, no Loading, no trouble
with your script, that is used in 2 columns, every time i get "Exceeded maximum execution time (line 0)."
It's not the same.
There are some internal limits to array sized on custom function, so if you have a very large table or super large number of empty rows you may end up hitting that limit.
@@ExcelGoogleSheets 😍i think so... there is limit on text to execute only on nonblanks?
I have an issue that I can find extensions besides the Tools and do not know why?
Excel file?
can you help me?. my output always error. in version 1.1 or 1.2. maybe something i miss ?
What's the error?
How to immediately auto lock cells after data entered in Google sheet
Please help me sir
hello. How do you install the function?
It's in the video.
@@ExcelGoogleSheets Thank you
🥴
=if(A1="free gift", "thank you buddy", " ") thank you buddy
😀
This is a masterpiece... its like a rock hit! I really really appreciate what you have done. Amazing job!!! Thanks a lot 👍👍🫶
Thank you so much 😀
Got error when trying to run this find-closest-match-google-sheets/v1.0/googleSheetsFindClosestMatch.js
TypeError: Cannot read property 'filter' of undefined
GETBESTMATCH @ Code.gs:11
i tied the exact formula and it has an error... i.imgur.com/DR3HpSP.png it seems the function no longer exists?
There are instructions in the video how to install the function.