Hello.
I have an spreedsheet file that has words in column A.
I want words with the same last three letters to be displayed in the B column.
What function should I use?
Hallo
→Data→Filter→Standardfilter:
Fieldname … Condition … Value
Col A … 'ends with' … 'xyz'
2 Likes
Thank you, But the words in column A dose not end only with “xyz” and may be any letter. For example:
abc
def
and so on.
If you want to sort by last three letters then extract last three letters with:
=RIGHT(A1;3)
into extra column, and sort by the ‘extra Column’
2 Likes