title: Get row number when using "MAXIFS" function
body: <p>I am using <code>MAXIFS</code> (or similar) to identify the wanted line in a table. but i do not need the max value, i need data from an adjecent column. Example:</p>
  
  <pre><code>=MAXIFS(TableComments1[CommentDate];TableComments1[T.Number];TableView1[@Number])
  </code></pre>
  
  <p>Basically, in this example i am searching for lines, matching <code>"Number"</code>, with the latest date. But in a next step i require to get the row number of the date to enable the use of <code>INDEX</code> and return the appropriate column (<code>TableComments1[Comment]</code>). </p>
  
  <p>I tried different approaches - no success. 
  PS: performance is also important here.</p>
  
  <p>UPDATE, example lookup table:<code>"TableComments1"</code></p>
  
  <pre><code>T.Number      | Comment      | CommentDate
  ==============+==============+===========
  SCTASK0073347 | correction   | 22/07/2018
  SCTASK0073347 | update 11    | 25/07/2018
  SCTASK0073347 | update 2     | 21/07/2018
  </code></pre>
  
  <p>PS: sorting <code>"CommentDate"</code> is not an option here.</p>