Rank 3 Columns, Rank Next 3 Columns, Rank Next 3...Etc.

Hi,

I have a large Excel document with a list of companies in the rows, and attributes in each column, and I'd like to create a macro that will rank the company list based on each particular attribute. I could do this manually with filters, but since I'm dealing with so many columns, it'll take forever.

I've attached an example of the raw data, as well as an example of my desired final product. (Notice that I've copied the company list next to each data set prior to ranking, and I've also added an additional empty column to act as a spacer.) The file only has 3 "attribute" columns, but in practice it will have 30-40. Also, note that I need to rank it on the "Index" column.

DataExample1.xlsx

Any help with this would be greatly appreciated.

There is a similar case about how to simply filter with different criteria in Excel, please refer here: Filter in Each Group.