daymaker
07-19-2011, 09:43 PM
I'm creating an worksheet in excel 2007. I need to display the results in column J using this formula
Quote:
==IF(A2="","",IF(SUMPRODUCT(--($A$2:$A2&$F$2:$F2=A2&F2))=1,(20-H2)/20,(20-SUMIF($F$2:$F2,F2,$H$2:$H2))/20))
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 form 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%;
I believe I need to create user forms in column I & J and then pass the inputs based on the selected entries in the user form in column F to the user forms in column I & J. Also, please note that these new user forms in I & J should also use the formula entered in the respective cells.
Could you please help me create these user forms? I've attached the excel for reference.
Quote:
==IF(A2="","",IF(SUMPRODUCT(--($A$2:$A2&$F$2:$F2=A2&F2))=1,(20-H2)/20,(20-SUMIF($F$2:$F2,F2,$H$2:$H2))/20))
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 form 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%;
I believe I need to create user forms in column I & J and then pass the inputs based on the selected entries in the user form in column F to the user forms in column I & J. Also, please note that these new user forms in I & J should also use the formula entered in the respective cells.
Could you please help me create these user forms? I've attached the excel for reference.