The recorded counts are 18, 30, 24, 30, and 12. Put them in B2:B6 and use =LARGE(B2:B6,3) to find the third-largest observation.
Count positions even when values tie
Write the numbers in descending order on a scratch sheet. The two 30s take positions 1 and 2. The third observation is 24. The original source order stays available for tracing each record.

Illustrated rank check. Count both observations tied at 30.
Check whether the report needs distinct values
If the cutoff is the third distinct count, first build a list of unique numeric values. Here its third value is 18. Use COUNT to check that the relevant list contains three numeric values. If fewer are present, report that the cutoff is unavailable.

Illustrated distinct-rank check. Choose the interpretation that fits the report.



