That works great! However, in the sheet I use that formula, I was hoping to use it further down the sheet. For full clarity, I am attaching a new Excel sheet that shows all the calculations I will need using your formula. I will need your formula for cell B1153, C1153, E1153, and F1153. I tried using your formula in B1153. I tried switch B$2 with B$991, but it didn't work. Thanks in advance.

Average Without Duplicates.xlsx