hiya
i have a large spread sheet with about 1300 lines.
in column A i have the account number (100,101,102 etc) in column B to J i
have the information for each account.
what i would like to do is paste in several account# in a seperate column
then filter them out in column A

i have found this ... =COUNTIF($B$1310:$B$2618,"*"&A2&"*")0 and it works
but it only with letters, not numbers.

please help
--
deejay

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