Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have spreadsheet with 2 columns - names and values, say:
What formula can I use to find the maximum value for each name? (E.g. in column C in each row with John would be 5, with Mary - 17, etc.).
In my opinion simplest by far but offering much more than just what you ask is a pivot table:
You could though try:
=query(I:J,"select I, max(J) group by I")
Required, but never shown