Creating Dynamic Ranking Tables

[ssol2016]

Hey guys,

This is my first post on this forum.

I need help and am looking for resolution whether they may be a VBA formula or a different and more simple method with ranking a horizontal time series of calculation results from greatest to smallest in individual columns:

For example, I have the name of the row in column A and thereafter have values in the rest of the columns to the right of column A (B-AN to be exact). I need each column to sort itself from largest to smallest without messing up the sorting of the columns beside it.

Any help regarding this issue would be greatly appreciated. Let me know if you need any more clarification on the issue.

Thanks!

[Kaper]

With VBA it can be pretty easy. Try:

Please Login or Register  to view this content.

see attached file