'How can I combine three ranges in Google Sheets where there isn't always data in two of them and with a function on one?
I have three ranges of data from YouTube that I want to combine into a single table. The three ranges are:
- YouTube subscriber numbers by day (the days for the combined sheet will pull from here)
- YouTube videos with lifetime stats and publish date
- YouTube channel statistics by day
I have data for every day on the first--subscriber numbers--going back years. The videos have the publish date, and I want to do a unique count on videos so that they show on the day they were published (so: "How many videos were published on X date?"). And finally, showing the channel stats by day, which don't go back as far as the subscriber numbers, but will be every day going forward.
Here's an example sheet, open for editing that shows sample data for the three sheets as well as desired output.
https://docs.google.com/spreadsheets/d/1Ckif5Vo8rLo1HEPUqer7mhyCXfMGlIjdw1wMz6JcPfA/edit?usp=sharing
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|