Hi Sprogget,
Thanks for your suggestion and it looks like you are on the right lines but due to my complete lack of knowledge of excel beyond simple adding up rows or columns I will need something more specific. Each potential "=" cell needs to compare the value in the adjoining ranking cell with all the other ranking cells (Z3 to Z38). I am sure the formula won't be too difficult or long but I just don't know excel syntax or expressions.