title: Aggregate Data based on a column value in Excel
body: <p>I am editing this question completely, as the desired result is changed a bit now. Also, I do agree, this question was not properly put forward to you guys. </p>
  
  <p>I have a spreadsheet namely Main Spreadsheet, which contains the activities/rows as listed. I want to notify the assignees about the activities they will be performing and the dates as well.
  I am able to write an email sending macro, but the problem is to reach that stage!
  How can we sort, and then ensure that the recipient is only 1 person who is the assignee, and his name is not in the "TO" field more than once. (Applying the <code>for</code> loop creates the pain!)</p>
  
  <p>Main Spreadsheet:</p>
  
  <pre><code>Date    Assignee    Activity
  08/01   Player X    Activity 1
  08/01   Player Y    Activity 1
  08/02   Player X    Activity 2
  08/02   Player Y    Activity 2
  08/02   Player Z    Activity 1
  </code></pre>
  
  <p>Report to be computed:</p>
  
  <pre><code>Assignee    Activity List
  Player X    Activity 1
  Player X    Activity 2
  </code></pre>