Hi,
I am calculating Variability based on daily Production of analystmedian daily variability report.xlsx .
The Variability formula = (Median of Production count of agents falling within top 25% / Median of Production count of agents falling within bottom 75%) / Average of production.
Assumptions / Exceptions
1. If Rounddown count of top 25% = 0 then Top 25% Count = 1
2. The productivity is calculated and listed in the same worksheet daily. Thus the productivity cannot be sorted in descending order for a day.
The formula in attached worksheet works fine except whenever there is repetition of Productivity count.
I am open to VB / Array formula.
Please assist.
Thanks,
HP
Bookmarks