Finding the second best price ?
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 ?