I'm creating an worksheet in excel 2007. I need to display the results in column J using this array formula "=IF(AND($A$2:$A2=A3,MATCH(F3,F:F,0)=ROW())(20-(SUM($G$2:$G3)))/20,INDEX(J$2:J2,SMALL(IF(F$2:F3=F3,ROW(F$2:F3)),COUNTIF(F$2:F3,F3)-1)-1,1)-I3)".
This calculation is dependent on several columns entries. I want to show it in a specific format. In column F I've created a user forum with several items. If I select more than an option in column F, the results has to be displayed accordingly both in column I & J accordingly.
Lets say I select the entries abc, xyz in F2. Then after the calculation in column I & J, I want the results to be displayed in the following format:
In I2:
abc: 50% ; xyz = 50%;
In J2:
abc : 50% ; xyz = 50%;
Please note that the value 50% is just a dummy value used to show an example and not a result of actual calculation.
Is it possible to achieve this using macros easily?
This calculation is dependent on several columns entries. I want to show it in a specific format. In column F I've created a user forum with several items. If I select more than an option in column F, the results has to be displayed accordingly both in column I & J accordingly.
Lets say I select the entries abc, xyz in F2. Then after the calculation in column I & J, I want the results to be displayed in the following format:
In I2:
abc: 50% ; xyz = 50%;
In J2:
abc : 50% ; xyz = 50%;
Please note that the value 50% is just a dummy value used to show an example and not a result of actual calculation.
Is it possible to achieve this using macros easily?
