8 min
Nested Functions I Want To Hack
-
- Technology
Hi there! We are discussing nesting functions in Google Sheets this week! There's an accompanying video and spreadsheet demo linked below for you!👇
Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!
Episode Overview:I had a question in the comments on my most watched video asking how to count unique values in a comma-separated list. I was intrigued and made it my topic of conversation this week!
Here’s the functions we used: =UNIQUE(SORT(TRANSPOSE(SPLIT(JOIN(", ",A2:A),", ",FALSE))))
=COUNTIF(SPLIT(JOIN(", ",$A$2:$A),", "),E19)
The links to my video walkthrough and article are available below.
Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!
Resources mentioned:
Video Walkthrough of nesting functions and finding unique values30sec YouTube Short previewIn depth article on freeCodeCampFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis
Hi there! We are discussing nesting functions in Google Sheets this week! There's an accompanying video and spreadsheet demo linked below for you!👇
Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!
Episode Overview:I had a question in the comments on my most watched video asking how to count unique values in a comma-separated list. I was intrigued and made it my topic of conversation this week!
Here’s the functions we used: =UNIQUE(SORT(TRANSPOSE(SPLIT(JOIN(", ",A2:A),", ",FALSE))))
=COUNTIF(SPLIT(JOIN(", ",$A$2:$A),", "),E19)
The links to my video walkthrough and article are available below.
Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!
Resources mentioned:
Video Walkthrough of nesting functions and finding unique values30sec YouTube Short previewIn depth article on freeCodeCampFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis
8 min