LARGE and SMALL

Return ranked values such as the second-highest sale or third-lowest cost.

Practical example

=LARGE(D2:D50, 2)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.