Hello good lads...
I have an issue I can't manage to resolve in an elegant way so I turn to you.
I have 2 tables (attached an example), in the 1st there's a list of brands (1-22), a list that can and will be rearranged every month. And in the 2nd there are the brands score per the position.
I'm trying to arrange in the 3rd table the scores per brand – match (for example – Brand 1 should state: "1.000" in the first column, and "0.540" in the second column and so on).
I struggled with array formulas but it got too messy so I'd appreciate your assistance.
Thank you.
Bookmarks