Create unique list that populates a second sheet (not report)?
Hello, I'm having trouble figuring out the correct formula to populate a list of unique locations and totals their entries on a second sheet. I couldn't find a forum example that doesn't use a report. This needs to be on a second sheet because it will be used in other formulas and dashboards.
Sheet 1 includes a list of locations, activities, and results. It will continue to populate new rows that are generated from a form.
Sheet 2 needs to list the unique locations and total their results:
I've fussed with INDEX/DISTINCT/COLLECT and it's not working. Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!