hi
Here is the attached file
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Sep 9, 2009 at 9:28 AM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking formula.See attached, kindly help.
Regards
Hello Ramesh,
Can you plz put it in my file and send. That will be great.
Regards
On Wed, Sep 9, 2009 at 11:12 PM, Chanti-Hyd ramesh1...@gmail.com wrote:
{=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrngE14,rankrng)),0))+1}
I think this formula should work for you..
Thanks,
Ramesh
On 9 Sep,
use this formual, i think this should work
={SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrngE14,rankrng)),0))+1}
Use CTRL+SHIFT+ENTER after entering in the required cell instead of ENTER
Thanks
Ramesh
On Wed, Sep 9, 2009 at 9:58 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking
{=SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrngE14,rankrng)),0))+1}
I think this formula should work for you..
Thanks,
Ramesh
On 9 Sep, 21:28, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking formula.See attached, kindly help.
Regards
Text.xls
18KViewDownload
Enter the following array formula in cell G14 then copy it down to G22:
=RANK(E14,$E$14:$E$22,0)-SUM(IF(FREQUENCY($E$14:$E$22,$E$14:$E$22)0,0,1)*IF($E$14:$E$23E14,1,0))
This formula must be entered as an array formula using (Ctrl + Shift +
Enter).
This formula came from the website below: