title: Create ARRAY from RANGE & Return MAX Date - Google Sheets
body: <p>I have a DataSet that has LanguageCodes in Column A and Dates In Column B.</p>
  <p><a href="https://i.stack.imgur.com/yc1RA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yc1RA.png" alt="enter image description here" /></a></p>
  <p>I want to be able to get the MAX(DATE) for any given Language. I know this can be done using Filters. However I need to do the function in a google-formula.</p>
  <p>I've tried using the FILTER() and MAX() Functions in combination, with no luck - This query returns 0.</p>
  <p><code>=MAX(ARRAYFORMULA(FILTER(B:B,A:A=&quot;de-DE&quot;)))</code></p>