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
--
deejay