Hi,

I have a large data set for which I must calculate 'mean weighted scores' for many individuals. Although I know how to do this one at a time, I was wondering if there was a function (or VBA code which I'm less experienced with) which would allow me to do this for every individual at once.

\1

In the above example image I have manually calculated the Weighted Score for each person (ID 1, 2 and 3) but to do so I had to select the relevant cell ranges (e.g. C2:C6 and B2:B6 for ID 1) myself. Is there a way to automatically select these cell ranges based on the value in the ID column?

Thank you!