6 Replies Latest reply: Nov 15, 2017 11:18 PM by Monica Lingan RSS

    Largest unique value

    Johan R�sing

      Hi,

       

      I am trying to pull the largest value from one column based on a unique value in a different column.

      1. Column A contains order numbers (need highest number)

      2. Column B contains a serial number that I need a unique value from.

       

      AB
      1222

      2

      222
      3333
      4111
      5333
      6222

       

      I want the output to be something like this:

      AB
      4111

      6

      222
      5333