Re: $$Excel-Macros$$ Weighted Average till sum of exposure reaches certain value.

2014-07-09 Thread maryann
means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* maryann > > *To:* excel-...@googlegroups.com > *Sent:*

Re: $$Excel-Macros$$ Weighted Average till sum of exposure reaches certain value.

2014-07-09 Thread Fang
The weighted average will be a single number right? Thanks! Maryann Sent from my iPhone > On Jul 9, 2014, at 2:53 PM, Vaibhav Joshi wrote: > > How do you want output to be presented? > >> On Jul 9, 2014 8:45 PM, "maryann" wrote: >> Dear Guru, >> I would like to calculate the weighted averag

Re: $$Excel-Macros$$ Weighted Average till sum of exposure reaches certain value.

2014-07-09 Thread Vaibhav Joshi
How do you want output to be presented? On Jul 9, 2014 8:45 PM, "maryann" wrote: > Dear Guru, > I would like to calculate the weighted average of rating (weighted by > exposure) till the sum of exposure reaches certain value. please see table > below: > > BuyerExposureRating > 1

$$Excel-Macros$$ Weighted Average till sum of exposure reaches certain value.

2014-07-09 Thread maryann
Dear Guru, I would like to calculate the weighted average of rating (weighted by exposure) till the sum of exposure reaches certain value. please see table below: BuyerExposureRating 1900.006 2675.006 3675.006 4675.