Hello,
I am completly stuck trying to calculate the rank for a dynamic table (i.e. varying in size).
I have a table like this (generated by a macro)
SampleName-------¦Rating
Sample 1----------¦5.516666667
Sample 2----------¦5.320833333
Sample 3----------¦5.285416667
Sample 4----------¦3.985416667
I have so far defined an offset for the ratings, allowing for n Samples.
I now need a macro or something to calculate the ranking of the rating column whatever its size... and even better if it would extend to several columns... that would be great...
resulting in something like this
Sample------------¦Rating----------------¦Ranking
Sample 1----------¦5.516666667----------¦4
Sample 2----------¦5.320833333----------¦3
Sample 3----------¦5.285416667----------¦2
Sample 4----------¦3.985416667----------¦1
Thanks so much for your help!
Bookmarks