title: Google sheets: how to get the last value in the column that has the same value in the previous column?
body: <pre><code>Name    Number
  Alpha   5
  Echo    2
  Charlie 6
  Alpha   1
  Delta   5
  Bravo   7
  Alpha   3
  Echo    2
  Charlie 5
  Bravo   2
  </code></pre>
  
  <p>For example from above, I have names in column A and numbers in column B. </p>
  
  <p>I need a formula to get all the last value of a specific name, for example:
  Alpha should return 3,
  Bravo should return 2,
  Charlie should return 5 etc. </p>
  
  <p>I currently only know how to return the last value in the entire column with:</p>
  
  <pre><code>=INDEX(FILTER(I:I,NOT(ISBLANK(I:I))),ROWS(FILTER(I:I,NOT(ISBLANK(I:I)))))
  </code></pre>
  
  <p>But it cannot return the last value of a specific value from another column. </p>
  
  <p>Please help, thank you in advance. </p>