Filtering

[Dralla]

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.

[#2]

If you have new excel then
=FILTER(A:A, N(RIGHT(A:A,1)),"none")

[#3]

So i tried it on excel online instead, but it returned none all the way down

[#4]

@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")