6 Replies Latest reply on Jul 19, 2018 11:56 AM by Shinichiro Murakami

    Get Column 'B' Value from the Highest Value Row of a Column 'A'

     Arthur Valle

      Hey guys!

       

      I have a huge database and I want to Get Column 'B' Value from the Highest Value Row of a Column 'A'. What I mean is: After getting to know what's the highest value of column "A", I need to get the value of column "B" of this row which has the highest value of column "A".

       

      AB
      13
      62
      46

       

      In this example I should find 6 is the max value for column A, then get its column B value "2" so I can use that value in other calculations and so forth. How can I do that?

       

      Thaks in advance!