Ranking problem when returning a tie

[GabeKnight]

Hi,
I have a list of scores relating to performance of sites.
Each month the scores will update a league table.

The league table is auto populated and ranked. The problem comes when 2 sites have the same score and are ranked the same.
When the table is populated instead of getting the following example

P1 Site A
P1 Site B
P3 Site C
etc.

it gives the following

P1 Site A
P2 Site A
P3 Site C
etc.

How do I get it to show a tie between Site A and Site B and list both sites.
Please note I do not require a tie breaker (unfortunately)

The formula in use are

=RANK(League!T4,League!$T$4:$T$11,0)+COUNTIF(League!$T4:T4,League!T4)-1

to rank the sites


=OFFSET(League!S$4,MATCH(SMALL(League!U$4:U$11,ROW()-ROW(T$13)+1),League!U$4:U$11,0)-1,0)

to order the sites in a ranked table

Any help greatly appreciated thanks

 

[Jerry Sullivan]

Hi,

I think you were missing a "$" in your unique ranking formula
=RANK(League!T4,League!$T$4:$T$11,0)+COUNTIF(League!$T$4:T4,League!T4)-1

This should work...

Excel Workbook
	S	T	U
4	Site A	100	1
5	Site B	100	2
6	Site C	98	3
7	Site D	80	7
8	Site E	85	5
9	Site F	91	4
10	Site G	77	8
11	Site H	82	6
12
13	P1	Site A
14	P1	Site B
15	P3	Site C
16	P7	Site F
17	P5	Site E
18	P4	Site H
19	P8	Site D
20	P6	Site G
League

 

[GabeKnight]

Thanks mate.....
Its working now cheers.