Q: What is the title of the highest rated item from 2016?
I have titles (Table 1::B) that are labeled by year (Table 1::A) and have a percent value (Table 1::E) assigned to them.
In Table 2 I have used an AVERAGEIF formula to determine the average percent of anything with the 2016 label. I would also like column B of Table 2 to find the actual title name (Table 1::B) with the highest percent value (Table 1::E) for the corresponding year between (Table 2::A) and (Table 1::A). Essentially, the question being answered is "What is the Title of the highest rated (percent) item from 2016?"
Additionally, could I then further apply this same concept to get the average value of anything from a particular decade and also list the top title for each decade? The tricky part here is I can't simply use a direct IF statement because the decades are listed as "2010s", "2000s", etc. which don't show up in the original Table 1. Any ideas?
Thanks everybody for the help. This is just a fun side project that I sometimes like to do and then I often learn new concepts that I can use to assess data in my job as a teacher.
iMac (21.5-inch Mid 2011), OS X El Capitan (10.11.6)
Posted on Sep 5, 2016 12:14 PM




