Forum Discussion

Dralla's avatar
Dralla
Copper Contributor
Jan 27, 2023

Filtering

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.

excel

3 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jan 27, 2023
    If you have new excel then
    =FILTER(A:A, N(RIGHT(A:A,1)),"none")
    • Dralla's avatar
      Dralla
      Copper Contributor
      Jan 27, 2023
      So i tried it on excel online instead, but it returned none all the way down
      • mtarler's avatar
        mtarler
        Silver Contributor
        Jan 27, 2023

        Dralla my apologies, i didn't test it first and N() apparently doesn't play nice with arrays 😞  It is the perfect function for this and doesn't work so instead use this:

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

         

Resources