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 entered.

The formula for the ranking column is: =IF(B6=””;””;IF.ERROR(IF(H6=0;0;(H6/I6)*100);””))

The problem is that when I filter from highest to lowest all the cells without a value (“”) are sorted before the highest values.

Does anyone know how to solve this?.

Thanks,

Francisco

​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 entered.The formula for the ranking column is: =IF(B6=””;””;IF.ERROR(IF(H6=0;0;(H6/I6)*100);””))The problem is that when I filter from highest to lowest all the cells without a value (“”) are sorted before the highest values.Does anyone know how to solve this?.  Thanks, Francisco  Read More

​