filtering data from list

  • Thread starter Thread starter confused deejay
  • Start date Start date
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
 
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

Countif on imported data 3
Having difficulties using COUNTIF with filtered columns 3
How to Populate Data from a table to another 0
Sum Column C for duplicate account number in Column A 8
Date and amount of last payment 3
Fill in columns by matching a value on another sheet 3
Countif formula 2
If cell empty delete row 1

Back
Top