ranking data producing the same rank

[sfinns]

I have included a spreadsheet that attempts to rank share price relationship data choosing the highest ranking data too choos eteh appropriate stock, picking the stocks and then assessing the performance.. unfortunately the same rank appears for quite a bit of the data causing an error signal when i try and calculate the top ranking shares and their subsequent performance.

i want to be able to chose from 1 to 10 of the top performing ratios to figure out if I bought the shares what the performance would be for the week after.
if something ranks the same im indifferent which ranks first , i just want to have a clear rank that is not duplicated . also if the data registers at -100 it was not in existence and shouldnt be ranked at all.

many thanks

[Pete_UK]

You will need to build in some kind of tie-break in order to distinguish between stocks which have the same rank. Often this would mean adding or subtracting a small value to/from the price in another column, and then applying the rank to this helper column. For example, suppose you wanted to do it based on the position in your list - you might have something like:

=A1+ROW()/10000

if A1 contains the price.

Hope this helps.

Pete

[sfinns]

unfortuntaeley that requires a lot of manual intervention - there must be some way of ensuring it doesnt happen or can be ignored ?