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!

With your data in B3:AN3 try this formula in B5:

=LARGE($B$3:$AN$3,COLUMNS($A:A))

Copy to B5:AN5.