Re: $$Excel-Macros$$ Rank Formula required

2012-03-19 Thread Mahesh parab
Hi Pankaj PFA, Try : =RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2 wrote: > Shorter. Also enter using CSE (ctrl+shift+enter) > > =COUNTIF($F$2:$F$9,">"&F2)+**SUM(IF(F2=$F$2:F2,1,0)) > > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > -Original Messag

Re: $$Excel-Macros$$ Rank Formula required

2012-03-18 Thread dguillett1
Shorter. Also enter using CSE (ctrl+shift+enter) =COUNTIF($F$2:$F$9,">"&F2)+SUM(IF(F2=$F$2:F2,1,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Secret Shot Sent: Sunday, March 18, 2012 4:02 PM To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ Rank Formula required

2012-03-18 Thread dguillett1
See attached =SUM(1*(F2<$F$2:$F$9))+1+IF(ROW(F2)-ROW($F$2)=0,0,SUM(1*(F2=OFFSET($F$2,0,0,INDEX(ROW(F2)-ROW($F$2)+1,1)-1,1 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Secret Shot Sent: Sunday, March 18, 2012 4:02 PM To: excel-mac