Find n-th large number in different row and column range

If your sample data is representative of your actual data, with either text to be ignored or numbers to be evaluated:
With your sample data in A1:D5
and
F1: an ordinal to find.... 2
This regular formula ignores the text and returns the n-th largest value:

Please Login or Register  to view this content.

For the sample data, that formula returns: 140

Is that something you can work with?