Filtering data excluding empty values

Hi All,   I have a table where a column calculates a ranking value, but when another column has no data the formula causes the value not to be displayed so that the rankings appear as the names are...