Sorting cells with #NA error where the error is desired for charting

Hello All,

Does anyone know a way to sort #NA errors to the bottom of a list? I read a few posts that recommend eliminating the error condition - BUT THAT IS NOT THE DESIRED SOLUTION.

I want the errors because the list is used in charts and the #NA value is skipped as a data point.

These are charting data points but you don't care about their order?

Anyway, the simple approach would be adding a column with formulas like =COUNT(X99). When X99 evaluates as a number, that returns 1; otherwise, it returns 0. Sort on that column first in descending order (so all rows with numbers would be on top, all rows with #N/A on the bottom) then on the other columns as you need them sorted.

Hello htlngrv, order does matter. As I imagined, seems your recommendation is a helper column. Was just trying to avoid that. THANKS!

Far more often than not, additional cells with additional formulas provide the simplest and most robust ways to do things in spreadsheets.