I have a spreadsheet that has 20 rows. Depending on the input, not all rows
will be entered with data. Those without data will have #value!.

Problem is how can I formulate the ranking so that I can always see the
ranking of the 20 rows and the ranking will auto exclude those rows having
#value!?

Thank you.