Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering data from list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering a List | Excel Discussion (Misc queries) | |||
Filtering out top & bottom 2.5% in a list | Excel Worksheet Functions | |||
How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |