Uploaded September 2016 | Updated September 2026, 2 hours ago

---

Fun challenge from Mike Girvin! I added some solutions.
Download my file here: http://1drv.ms/1bYwrTa
00:00 Challenge intro
01:02 Mike Girvin's solutions!
01:13 Pros & Cons
01:51 Are there other solutions?
02:03 Method1: Remove Duplicates (quick & dirty)
03:00 Method2: Helper Column 1/countifs
05:40 Method3: Helper Columns Match & Sumifs
07:55 Method4: Array Formula 1/countifs (no helper)