Sort order (ranking) for miltiple columns of data

Hi, I am hoping someone can help me with a more efficient way to achieve what I am currently doing longhand.

I have columns A:K all with say 20 rows of data in them. I want to insert a blank column between each of the columns with data in in and then basically denote where the cell on the left sorts/ranks with respect to all the data in the column on the left.

Previously I have sorted by column A from largest to smallest and then typed in 1, 2, 3 etc into column B and dragged it down to the 20th row. Then for the data in column C, inserted a column to its right (D), sorted by C (largest to smallest), typed 1 into row 1, 2 into row 2 and dragged it down to the 20th row. And so on.

I'm hoping there's a function I can insert into columns B and D etc to do all this for me without having to manually sort columns A, C, E etc.

Attached is a sample of what I am referencing. The yellow columns are the ones I want to automate.

Does anyone have any ideas that may help me?

Thanks in advance.

Greg.

Hello Greg,

in B1 use

=RANK(A1,A$1:A$20)

copy down. Then copy the formula to D1 and F1 and copy down the respective columns.

cheers