$$Excel-Macros$$ Urgent_ Need ranking formula

2009-09-09 Thread vinod rao
Hello Team, Need ranking formula.See attached, kindly help. Regards --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-i

Fwd: $$Excel-Macros$$ Urgent_ Need ranking formula

2009-09-09 Thread Chanti
-- Forwarded message -- From: Chanti Date: Wed, Sep 9, 2009 at 11:08 PM Subject: Re: $$Excel-Macros$$ Urgent_ Need ranking formula To: excel-macros@googlegroups.com use this formual, i think this should work ={SUM(IFERROR(1/COUNTIF(rankrng,IF(rankrng>E14,rankrng)),0))+1}