filtering data from list

C

confused deejay

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
 
C

confused 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Search cell value in same column 3
Filtering data from a non-continuous list 3
Multi-demensional frequency distribution 4
Index/Match Lookup with a merged col 2
Countif on imported data 4
Trying to figure the formula 1
Sum Column C for duplicate account number in Column A 8

Top