rank index table

**Merv** · 12-22-2009, 08:36 AM

Hi,
Have a series of tables that are put in order ascending and desending using rank and index.
the problem is the last 3 tables

short calls ranking and hang ups which puts #n/a instead of the persons name

long calls ranking which doesnt put them in any sort of order at all.

been wrecking my head trying to see where i have gone wrong with these two, can any1 help?

**NBVC** · 12-22-2009, 08:42 AM

The #N/A means the number/name you are trying to match does not exist in the list you are looking in.

**Merv** · 12-22-2009, 08:52 AM

i've done a few of these for each week in the past month, but it seems to only happen when there is a large number of people with the same number of hang ups/short calls etc.

is there any way around this?

**NBVC** · 12-22-2009, 08:59 AM

Do you want to use unique ranking so that no 2 numbers have same rank..

e.g. try in T4:=IF(Q5<>"0",RANK(Q5,$Q$5:$Q$40)+COUNTIF($Q$5:Q5,Q5)-1,"")

and in AN4:=IF(R5<>"",RANK(R5,$R$5:$R$40,1)+COUNTIF($R$5:R5,R5)-1,-1)

copy both down... no more #N/A except for the one in AI24.. but that name is not found in column A.