Hi Narayan,
thanks for your reply, but you will notice for example there are quite a few duplicates in the data, (e.g. A231 & A232 are the same value) yet the rank calculation worked in all cases but the one I highlighted as the problem.
Hi Bosco,
that is useful to know, but definitely not...