title: VBA- picking one cell for each column that contain certain text in a Matrix with the max number of rows selected
body: <p>I have a matrix of information that let user to input task they are willing to do. User have 3 choices: </p>
  
  <p>A. I want to do this.<br>
  B. I do not mind doing this. and<br>
  C. I do not want to do this.</p>
  
  <p>after I collect user data, I'd like to assign each task to each person base on their will (pick A over B) (pair up one task - one person). Are there any advice on how I can  do it?</p>
  
  <p>note:</p>
  
  <ul>
  <li>column labels are user name and rows are tasks.</li>
  <li>Obviously there are some task no one are willing to do and it is ok to leave it blank. (the number of task are expected to be greater than number of user, so some task will be blank anyhow)</li>
  <li>I do not need all possible solution, just 1 solution will do</li>
  </ul>