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? You...
excel
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