jb
Member
Hi all experts,
I have an excel sheet with 5 columns with title - serial number, T (means type having only 2 possible values: G and P), S (means gender having only 2 possible values: M and F), A ((means area having only 2 possible values: R and U) and Score.
Now, I want to extract rows based on different combination on T, S and A columns.
For e.g. T=G S=M and A=R - this combination has roughly 140 rows.
I want to have 3 combobox on new output sheet, and based on selection output will be displayed below it.
When I select this combination, I want to fill this 140 rows on output sheet.
Also when I change combination, same output area must be filled with rows satisfying new combination.
I am attaching sample file here.
I have an excel sheet with 5 columns with title - serial number, T (means type having only 2 possible values: G and P), S (means gender having only 2 possible values: M and F), A ((means area having only 2 possible values: R and U) and Score.
Now, I want to extract rows based on different combination on T, S and A columns.
For e.g. T=G S=M and A=R - this combination has roughly 140 rows.
I want to have 3 combobox on new output sheet, and based on selection output will be displayed below it.
When I select this combination, I want to fill this 140 rows on output sheet.
Also when I change combination, same output area must be filled with rows satisfying new combination.
I am attaching sample file here.
