title: Compare Excel rows within a table
body: <p>I have an Excel table (which is formatted as table and named as "table 1"). So the table columns are named like @LastName, @FirstName and so on.</p>
  
  <p>This table contains information on when people attended a seminar. They're able to attend a number of seminars but also can attend a single seminar twice or more often.</p>
  
  <p>I now want to find out, when the last date was , when a person attended a special seminar.
  Lets give an Example:</p>
  
  <p>Table:</p>
  
  <pre><code>@FirstName  @LastName @Seminar     @Date
  Frank       Mayer     Workshop 1   2017/01/15
  Frank       Mayer     Workshop 2   2019/05/27
  Sabine      Adams     Workshop 1   2017/01/15
  Volker      Mueller   Workshop 1   2017/01/15
  Frank       Mayer     Workshop 1   2018/04/23
  </code></pre>
  
  <p>As you can see from this simple example, Frank Mayer attended Workshop 1 2x. All others attended each Workshop only once.
  Goal is to have a list of Name, Workshop and last attendance. So the final list should look like:</p>
  
  <pre><code>@FirstName  @LastName @Seminar     @Date
  Frank       Mayer     Workshop 2   2019/05/27
  Sabine      Adams     Workshop 1   2017/01/15
  Volker      Mueller   Workshop 1   2017/01/15
  Frank       Mayer     Workshop 1   2018/04/23 
  </code></pre>
  
  <p>I really have no idea how to solve this with Excel Formulas, since there is not only comparing dates, but also find double entry which differ only with the date. If possible, I'd like to NOT use VBA programming.</p>
  
  <p>Do you guys have any idea? My table has 1500 lines, so doing that by hand is not an option...
  Maybe there is a way to create a new sheet or table with the results?</p>
  
  <p>Best Regards
  Olaf</p>