Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 23 Mar 2014 21:22:41 +0100How do I find the first and last matches in a dataset?https://ask.libreoffice.org/en/question/31781/how-do-i-find-the-first-and-last-matches-in-a-dataset/Suppose I have the following data set...
<br> _ A B
<br> 1 1 9
<br> 2 2 10
<br> 3 3 11
<br> 4 2 11
<br> 5 3 12
<br> 6 3 13
<br><br>
(Column A is the team number and column B is the age of the kid).
Suppose I want to know the youngest kid on team 2. I figured out the first match. I can say,
<br>=INDEX(B$1:B$5,MATCH(2,A$1:A$5,0),1)<br>
...and it would tell me that the youngest kid on team 2 is 10yrs old. How would I find the oldest member of a team? I want to say, how old is the oldest kid on team 2 and have it respond "11", or how old is the oldest kid on team 3 and have it respond "13".
Thanks!
M_BisonSun, 23 Mar 2014 21:22:41 +0100https://ask.libreoffice.org/en/question/31781/