00:00How do you rank column with non-numeric values? Like my data set here where I have dashes on the
00:06net worth column. If you try to apply the rank function like this, gonna say equal rank open
00:11parenthesis c5 in net worth column, press f4 to make absolute reference in descending order,
00:17we get the rank value of 2 in my data set. But if we apply the same formula to rows
00:23with net worth
00:24of dash, we get a value error. A good way to get around this would be to encapsulate the rank
00:29function with the if error function like this, and if there is an error, we'll assign the last index
00:35in the rank using the countif function like this. Apply the same formula to the rest of rows, and now
00:41if we apply filter based on rank number, we can see that all rows with dashes are at the bottom
00:47of the
00:47table.
