Rank(), ignore #NUM! and #N/A N/A

[maxfiesta]

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

[AndyLitch]

Change your main data table calculations so they don't post error messages.

e.g. If(IsError(Yourfunction),"",Yourfunction)

[maxfiesta]

Thanks so much!

[AndyLitch]

Your Welcome