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 |
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 |
All times are GMT +1. The time now is 07:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com