Hello friends!
There are 7 columns ,A10:G110.
A2:F7 ,Represents all possible combinations .
For example ,A2=columns A AND B ,C3=columns C AND E ,F2=columns F AND G
D4=columns D AND G ,Etc.
M1 AND N1,Those cells that change, and according to this determined which combination is suitable.
I2 ,The best combination ,
J2 AND K2 ,These two columns, with the best combination.
Now we reached a crucial point,N2 Is a short formula, that summarizes all A2:F7 ,
My problem with this beautiful formula, which is volatile and I want to replace it.
M2 ,The same solution as N2 , but significant long.
Thank you !
There are 7 columns ,A10:G110.
A2:F7 ,Represents all possible combinations .
For example ,A2=columns A AND B ,C3=columns C AND E ,F2=columns F AND G
D4=columns D AND G ,Etc.
M1 AND N1,Those cells that change, and according to this determined which combination is suitable.
I2 ,The best combination ,
J2 AND K2 ,These two columns, with the best combination.
Now we reached a crucial point,N2 Is a short formula, that summarizes all A2:F7 ,
My problem with this beautiful formula, which is volatile and I want to replace it.
M2 ,The same solution as N2 , but significant long.
Thank you !