Hi, long time user of the forum but first post so please go easy.
I’ve hit a roadblock creating a slightly complex AVERAGEIFS formula.
I basically need to create an AVERAGEIF formula with multiple criteria, the challenge is I have some duplicate items where for these rows I only want to factor in the lowest respective value to the average. Suspect I need to utilise the MIN function but can’t quite seem to get it functioning correctly.
I’ve attached an example sheet to help illustrate what I’m trying to achieve. It is the rank column which I want to capture the average for. A keyword may rank multiple times but I only want to include within the average calculation the lowest value. At present this isn’t factored (keyword column) into the included formulas.
The sheet is a cut down example so the intention of the formula may not be fully obvious but with a much bigger data set in would likely more clear.
Thanks in advance for any help.
Bookmarks