That's better!
Bob
"Andre Croteau" <milandre@bigpond.net.au> wrote in message
news:X2nGe.65962$oJ.14281@news-server.bigpond.net.au...
>
> Hi,
>
> Another solution could be done this way... In cell C1
>
>
=RANK(B1,$B$1:$B$40,1)+(COUNTIF($B$1:$B$40,B1)<>1)*((COUNTIF($B$1:$B$40,B1)-
> 1)/2)
>
> André
>
> "assws" <assws.1svuus_1122559535.2194@excelforum-nospam.com> wrote in
> message news:assws.1svuus_1122559535.2194@excelforum-nospam.com...
> >
> > Good Morning,
> >
> > The data I have looks like this
> >
> > Bob 193
> > Scott 193
> > Paul 204
> > Ringo 149
> > JohnL 148
> > George 172
> > Pete 148
> > Rodger 148
> > Keith 168
> > JohnE 118
> >
> > Using RANK(B1,$B$1:B$10,1) I can get the ranks but when there is a tie
> > I want to get the average of the 2 values of the tie. So if the 2nd
> > place is a tie with the 3rd place then (9+8)/2 = 8.5. It also has to
> > allow for a three (or more) way tie for example the 7th, 8th and 9th is
> > a tie so (2+3+4)/3 = 3
> >
> > result What I want
> > Bob 8 *8.5*
> > Scott 8 *8.5*
> > Paul 10 10
> > Ringo 5 5
> > JohnL 2 *3*
> > George 7 7
> > Pete 2 *3*
> > Rodger 2 *3*
> > Keith 6 6
> > JohnE 1 1
> >
> > Thanks in advance
> >
> >
> > --
> > assws
> >
> > Married w/ 1.5 Kid
> > ------------------------------------------------------------------------
> > assws's Profile:
> http://www.excelforum.com/member.php...fo&userid=4929
> > View this thread:
http://www.excelforum.com/showthread...hreadid=390916
> >
>
>
Bookmarks