In Excel 2010 there is a new Average Rank function. If 2 values are the same and come in at second place then they get 2.5 each (versus 2 & 2 for Rank function). If 4 values came in second they would get 3.5 each and no second, fourth or fifth place versus all getting 2 in Rank. Take a look at http://www.actionebiz.com/exceltraining.htm for more Excel 2010 training
Bert Twomey
Excel Trainer
MS Excel 2010 new function Rank.AVG training Toronto, Mississauga
No comments:
Post a Comment