Go offline with the Player FM app!
Nested Functions
Manage episode 356309713 series 3018946
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 values
- 30sec YouTube Short preview
- In depth article on freeCodeCamp
- Find me on my site
- Watch me on YouTube @eamonncottrell
- Follow me on Linkedin @EamonnCottrell
- Buy me a coffee on BuyMeACoffee
- Laugh at me on gitHub @sieis
35 episodes
Manage episode 356309713 series 3018946
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 values
- 30sec YouTube Short preview
- In depth article on freeCodeCamp
- Find me on my site
- Watch me on YouTube @eamonncottrell
- Follow me on Linkedin @EamonnCottrell
- Buy me a coffee on BuyMeACoffee
- Laugh at me on gitHub @sieis
35 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.