Рет қаралды 4,017
🚀Join my free tech newsletter: got-sheet.beeh...
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): docs.google.co...
Full article at freeCodeCamp: www.freecodeca...
😀 Please subscribe to my channel for more coding and spreadsheet content: www.youtube.co...
You can find more of my work including articles and podcasts on my website at www.eamonncott...
#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: amzn.to/3NLn57r
►Keychron's Full Product Line...amzn.to/3rtitv7
►DeltaHub Ergonomic Wrist rest. I was skeptical, but it has done wonders for my desk-wrist soreness. amzn.to/3O7cRQi
►Uplift Standing Desk...I love this thing. I also sit at it a lot, which I'm ok with 😀amzn.to/3XPAmAM
►Logitech THX 2.1 Speakers...great sound at an affordable price... amzn.to/3D9InXr
►Phone stand for Desk...surprisingly handy to have phone on a stand. And cheap...amzn.to/3D8ODid