Hi all,
Wondering if someone could help.
I'm trialling a new method of data collection from a beer tasting panel where we have several tasters who report different flavours as codes (called terms) and their intensity (called weight) and then give the product an overall score. We have up to 8 people at a time.
Currently we just add all the scores together and input them on a sheet manually, but I wanted to try create a sheet where we store all the results and report back as well.
What I'm trying to do is, collect all the unique "terms" in an array and deliver the average "weight" as a summary for each individual product tested. I've has a look through the forum and can't quite find what I'm looking for. I've attempted myself via google using the UNIQUE function, but I'm struggling when it's spread across multiple columns. If there's a simpler way of doing it that saves time using a calculator and averaging dozens of values then entering then back in a different sheet, then I'm all over that.
I've attached my (very) rough attempt.
Thanks for your time.
Bookmarks