Weighted Rank/ Average Query

[TBC]

I thought I knew how to do a weighted rank but I'm having problems with the results. Could someone please provide me the calculations to do a Weighted Rank and a Weighted Average? If you need more back ground, please ask.

Thanks
TBC

 

[vbaInet]

As with questions of this nature, let's see a sample of the raw data and the desired results in a spreadsheet or as a screenshot.