HI Moose,
I cannot check custom cells as my subscription is out and I am trying to get my head around the options before renewing.
What I can confirm is that in Excel 2013 the function RANK() works.
See attached png file.
Formula = RANK(N4,N$4:N$13,1)
Notice that the empty cells have #N/A, which is easily fixed.
Hope this helps.