I have 3 Brand Names with 2 columns of data each.
Here is the first data of 'Brand A' .... (Brands B & Brand C are in adjacent columns)

Brand A
col1 col 2
$1 $2
$7 $8
avg(A3:A4) avg(B3:B4)

Summary
maxValue(columns 1, 3 5) --> Brand 'x'
2nd maxValue(columns 1, 3 5) --> Brand 'y'
3rd maxValue(columns 1, 3 5)--> Brand 'z'


Trying to extract Brand Name from the main table in the Summary Table.

Thanks,