don't fret over a complex expression when you can easily remove those duplicates. Returning the average value for a set of values in Microsoft Excel is as easy as dropping in an AVERAGE() function ...