View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
confused deejay confused deejay is offline
external usenet poster
 
Posts: 37
Default filtering data from list

sorry everyone i've answered my own question done abit of changing around and
simplified my problem and came up with =COUNTIF(M:M,A2)0
then filtered *true* in column L and i get the list i want :):)

spose it's true what they say.... learn to walk before you run!!!! lol

--
deejay