Hi ...
I have treid with Filter, xlookup, search and much much more, but ...
D1 is where the wanted formula will reside.
Column A1:A3 contains a list of words.
C1:C3 contains one letter each.
How du I get a list of words from column A1:A3 containg only of the letters in C1:C7
Same letter can be used more than once.
eks.:
Column A
train
cart
plane
aeroplane
streetcar
tram
art
C1:C3
a
r
t
Output with spill in D1:
train
cart
plane
aeroplane
streetcar
tram
art
I tried =FILTRER(A1:A7,ISNUMBER(SEARCH(C1&"*",A1:A7))) in D1, but it does not give the correct answer.
It lists all words containg these letters and others, not words containing of only these letters.
All I want is the last word art.
VBA?
Bookmarks