Rank if between 1 & 5

T

tmirelle

Have managed to rank data,

would like it to produce the following

if rank is between 1 & 5 show the rank; if not show 0
 
D

David Biddulph

=IF(RANK(A1,A$1:A$25)<=5,RANK(A1,A$1:A$25),0) or
=(RANK(A1,A$1:A$25)<=5)*RANK(A1,A$1:A$25)
 
T

tmirelle

Thanks,
2nd one seems to work (sort of)

not getting unique ranks... i.e I have 3 ranked at #2 cause they are the
same value

probably would still work for my purposes, will have to investigate further
 
T

tmirelle

Thanks, #2 seemed to work mostly...

I have been messing around with this a little more & think I have a better
handle on what I am after.

this is the equation I am using

=SUMPRODUCT(--('06.07'!$B$1:$B$1000='06.07Analysis'!B$1),--('06.07'!$F$1:$F$1000='06.07Analysis'!$A14))

Now what I would like to do is:

If the above function is in the Top 5 (i.e. ranks between 1 & 5) then
display the result to the equation above. If not then return 0
 
Top