title: Using Google Sheets Query to get Max Date for rows of data
body: <p>I've been trying to use Google Sheets Query to find the more recent data of a particular name while pulling the rest of the data from the row. And having not luck.</p>
  
  <p>This is a sample of what the Raw Data looks like:
  <img src="https://i.stack.imgur.com/jo368.png" alt="raw data"></p>
  
  <p>And this is the output that I would like to achieve:
  <img src="https://i.stack.imgur.com/5cjFf.png" alt="Output"></p>
  
  <p>The closest I got to the output that I need is</p>
  
  <pre><code>=QUERY('Raw Data'!A:F,"select max(A), B, C, D, E group by B, C, D, E",1)
  </code></pre>
  
  <p>But the most important data is in F. When I add in F to 'select' the formula breaks, so I also grouped by F. Then that also pulls in the 4/1/17 data for Mark.</p>
  
  <p>Anyone know whats going on? Or have a better formula for me to work with?</p>
  
  <p>Thanks!</p>