Hi everyone!
I am working on a large spreadsheet with a lot of returns and valuation ratios and want to rank stocks based on these. For many stocks some ratios are missing but I still want to rank those that have data. Is there a way to use the rank() function and exclude/ignore cells with "#NUM!" and "#N/A N/A" from the ranking?

Thanks