Скачать с ютуб Google Sheets Tutorial - Counting Unique Values Within Comma Separated Data в хорошем качестве

Google Sheets Tutorial - Counting Unique Values Within Comma Separated Data

🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/ How to find unique values in a data set when cells contain more than one value separated by commas. And how to count the number of occurrences of the values. Dataset scraped from IMDB. Google Sheet linked below 👇 00:00 Intro and Summary 01:12 =UNIQUE() function 01:55 =JOIN() function 02:33 =SPLIT() function 03:00 =TRANSPOSE() function 03:25 =SORT() function 03:40 Nested function for Unique Values 05:30 Finished Result 1 05:55 =COUNTIF() nested function 07:20 Finished Result 2 08:15 Conclusion and subscribe Google Sheet Demo (make a copy by clicking File - Make a Copy): https://docs.google.com/spreadsheets/... Full article at freeCodeCamp: https://www.freecodecamp.org/news/nes... 😀 Please subscribe to my channel for more coding and spreadsheet content: https://www.youtube.com/@eamonncottre... You can find more of my work including articles and podcasts on my website at https://www.eamonncottrell.com/ #googlesheets #excel #spreadsheet ⭐⭐Some of My Computer Desk Gear for Data Analysts (affiliate links support my channel's growth 😀) ►Keychron Q5...my new favorite; it's lovely especially with the quiet keycaps: https://amzn.to/3NLn57r ►Keychron's Full Product Line...https://amzn.to/3rtitv7 ►DeltaHub Ergonomic Wrist rest. I was skeptical, but it has done wonders for my desk-wrist soreness. https://amzn.to/3O7cRQi ►Uplift Standing Desk...I love this thing. I also sit at it a lot, which I'm ok with 😀https://amzn.to/3XPAmAM ►Logitech THX 2.1 Speakers...great sound at an affordable price... https://amzn.to/3D9InXr ►Phone stand for Desk...surprisingly handy to have phone on a stand. And cheap...https://amzn.to/3D8ODid