2nd and 3rd top value

Andre_Zijlstra · ‎Jan 31, 2020

Hi everybody, in Excel you can use a MAX formula and set it in such a way that it renders the top value, the 2nd best, 3rd best and so on.

Is this possible in Airtable?

The Max formula doesn’t seem to allow me to add these parameters.

Regards,
André

Justin_Barrett · ‎Feb 01, 2020

I’m afraid that the MAX() function in Airtable hasn’t been built with the same flexibility as its equivalent in Excel. However, there may be another way to achieve what you want. Would you please share more details about your base design and specific use case?