Hi,

I am trying to calculate the average value for all items in each quater but there are a lot of duplicate items that I do not want their values be double counted in the average calculation. I could simply filter duplicates and get the regular average, but I cannot do that everytime for a lot of data. Therefore, I need a VBA Macro (guessing a loop one) that averages the "Quarter Values" column for all IDs if those IDs are not a repeat. (its okay for the values to be repeat because different IDs could possibly have same values). I also need the average only count for and sum positive numbers, not zero or negatives or texts. The last row is variant.

I would need the Macro be linked to the 'Calculate Button' on the Average Sheet.

test.xlsx

Thanks a lot