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.

Sorted positions show 30, 30, 24, 18, and 12 without changing the original sheet.

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.

Removing repeats yields 30, 24, 18, and 12, so the third distinct value is 18.

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

Microsoft’s LARGE function reference