Judging from what you say there, you will need a sort of ranking system. Try using the RANK function and see what it does.

It would help if you could post a sample workbook for us to look at and play with.