Home > Enterprise >  Excel filtering data
Excel filtering data

Time:01-27

I need help.

I have a thousand rows in 1 column. Each rows either end with a digit or a letter. And this letter ranges from A until RR. How can I select all the values that end with digit only?

Your help is much appreciated. Please respect my post.

I tried to used "not ending with" option in Filter. But i can only have 2. Is there a way to range the filter values from A through RR?

CodePudding user response:

Assuming the input data is in column A, I consider the entire column, but you can adjust it to your specific range, then you can use:

=FILTER(A:A, ISNUMBER(-RIGHT(A:A,1)))

It returns the rows from column A that ends with a single digit. We use the minus sign (-)to convert a text into a number. If it is not a number returns #VALUE! and in that case ISNUMBER returns FALSE, otherwise it returns TRUE.

  • Related