5 Replies Latest reply on Feb 19, 2010 12:34 AM by Macl007

    Finding the second best price ?

    Macl007

      Title

      Finding the second best price ?

      Post

      Hey,

      I'm trying to write a formula that will give me the second best price out of a series of prices. I explain myself.

      Let's say that I have 4 fields, Price1, Price2, Price3 and Price4. I would like to a have a 5th field that would give me the second best price out of the 4 prices. 

       

      Can anybody help me because I cannot see how to do that ?

       

      Many thanks