Hello Buddies, I have a table that looks like the one I attached. I would like to find maximum of a specific cell (horsepower), for each second Column. And then Return the Best 3 (or sometimes best 4, 5, 6… as well) of all the Columns to a result table. It should contain the left info column as well to each of the 'winners' (max's). The table can have more columns (even numbers since it pairs two) and do not necessarily have to have exact number of rows (as shown).. The table looks exact as attached. Anyone have some idea to handle this problem?
Hope to hear from someone, -Best Martin
Best Answer