Hello members,
I would like to write VBA macro for listing the missing variables as per below.
<tbody>
</tbody>
The expected outcome will be looked like as below:
<tbody>
</tbody>
Your kind assistance is greatly appreciated.
Many thanks.
Regards,
Ryan
I would like to write VBA macro for listing the missing variables as per below.
Among candidates A, B C, D and E. I would like to list down the missing variables (Hobbies), accompanied by the candidates name.
Hobbies | A | B | C | D | E |
Swimming | Y | Y | Y | N | N |
Tennis | N | Y | Y | Y | N |
Badminton | N | N | Y | Y | Y |
Volleyball | Y | N | N | Y | N |
<tbody>
</tbody>
The expected outcome will be looked like as below:
Hobbies | Candidate |
Tennis | A |
Badminton | A |
Badminton | B |
Volleyball | B |
Volleyball <strike></strike> | C |
Swimming | D |
Swimming | E |
Tennis | E |
Volleyball | E |
<tbody>
</tbody>
Your kind assistance is greatly appreciated.
Many thanks.
Regards,
Ryan