Forum Discussion
pescadicto
Helper I
Helper IHow to scale a multi-categories / multiple vales using another table with factors
Hi! I need some help: I want to scale the first table using the factors of the second table to get the third table: The indexes in the first table are repeated (you can think of them as ca...
pescadictoHelper I
Helper Ilbendlin you right, I founded the brute force in the table FACTORS. Thanks.
lbendlin
Super User
Super Userhere is some inspiration if you want to investigate further
Excel Matrix Multiplication - Replacing MMULT with Power Query - DataChant
It's a bit overkill but can serve as guidance.