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.
Bookmarks