title: Query or Filter the Highest Value with Conditions
body: <p>so I have this thing here below. I have been breaking my head for the past 2 days trying to figure it out.</p>
  
  <p><a href="https://i.stack.imgur.com/YpG0H.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YpG0H.jpg" alt="Tada"></a></p>
  
  <p>On a separate page, I want to be able to know THE DATE of someone's best performance (Fronts, Spiffs, Apps separately) so I've tried the following</p>
  
  <pre><code>=offset(index('Junkyard 2'!K2:K1999,(MATCH(MAX('Junkyard 2'!K2:K1999),'Junkyard 2'!K2:K1999,0))),0,-9)
  </code></pre>
  
  <p>That gets me the date with the highest number but it is not necessarily from that person</p>
  
  <p>So I've tried </p>
  
  <pre><code>=FILTER('Junkyard 2'!B3:B2000,'Junkyard 2'!C3:C2000=B4,LARGE('Junkyard 2'!K3:K2000,1))
  </code></pre>
  
  <p>And it gives me this </p>
  
  <blockquote>
    <p>FILTER has mismatched range sizes. Expected row count: 1998, column count: 1. Actual row count: 1, column count: 1.</p>
  </blockquote>
  
  <p>So now I've tried query but I'm shit at query to be honest, don't understand much. </p>
  
  <pre><code>=QUERY('Junkyard 2'!B3:O2000,"select B, Max(K) group by B"  )
  </code></pre>
  
  <p>This gives me the maximum of each day..again, not neccesarily done by the guy. </p>
  
  <p>In a jist, I want to be able get the Day with Highest Number of Fronts/spiffs/apps that a guy I choose have done. It's so annoying.</p>
  
  <p>Please help</p>