filter part info

[confused deejay]

hiya i'm still stuck on my spread sheet well actually i've been given a new
problem

here's my sheet

(B)data (L)filter (m)input
andrew lees =countif(M:M,B:B) ANDREW
deejay royall sheila
sheila royall deejay

column L won't filter M because its only part of B is there a formular to
adjust this so if i filter deejay in M deejay royall will show in B???

thank you for your time

 

[PCLIVE]

Maybe this:

=COUNTIF(B:B,"*" &M:M&"*")

HTH,
Paul

 

[confused deejay]

Hiya mate tried ya formular didn't quite work

this is what happened
(A) (B) (K)
(M)
10027 Abbey Films/Cinema and General 1 ABBEY FILMS
10035 Aberdare Coliseum Theatre 1 ABerdare COLISEUM
10036 Aberdeen Belmont City Screen 0 ABERDEEN VUE
10037 Aberdeen Lighthouse Vue 7 Cinema 3 ABERDEEN
10039 Aberdeen Cineworld Cinema 9 1308

notice aberdeen vue wasn't found because in column (B) its aberdeen
lighthouse vue can this be corrected? Also when (M) is aberdeen it shows 3
in (K) because 3 lines have the word aberdeen what i wanted is to filter (K)
so it shows results in (B) to the list picked in (M) *i do realise aberdeen
in (M) will confuse things it will never just be one word i've put it on to
show what results were coming up with* however things like aberdeen vue will
be on there!