• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter data in place help

J

j_sun

Member
Hi,

Is there a way to filter a list, in place, based on the following logic:


Column A begins with "C" and length >6


I know I can create a helper column with a formula to evaluate the above but I was wondering if you can do this with the Advanced Filter or some other tool (I can't seem to grasp Advanced Filter for some reason)


Thanks,

Jason
 
ok, fine, im not always good at this whole 'leaving you hanging' game


advanced filter is right on!!


Let me work out the details and i'll get back to you, Jason.


ok...im back. somewhere off to the side (or on another sheet) type or copy the heading of Col.A into a cell. below this cell, type "C?????"


Then select one of the cells in ColA on your orignal sheet (where the data is that we're filtering). Then open the advanced filter. and specify the following.

-- verify 'filter in place' is selected

-- enter the cell range where the list is located (EX-- A1:A100)

-- Enter the location of our criteria (EX-- AZ1:AZ2)

* you can also click on the little box/picture/icon next to these fields if you prefer to set these ranges with your mouse (click and drag)

-- then press ok!


Check this out for more info and pics: http://www.contextures.com/xladvfilter01.html#WildCard
 
i wanted to add... if you choose to 'filter in place' you'll need to 'clear' or turn off the filter to see the whole list again.
 
Hi Jason,


Could you please download the file from here?


http://speedy.sh/YdJ6G/J-Sun-Chandoo.org.xlsm


Instruction:


1)In sheet1 click on "Click Me" button to get the data filtered


2)Data will be filtered based on " Text in Col A starts with the letter "C" and word length is >=6". Once the data is filtered, you will get to see true in Col B.


3)If you want to get rid of filter mode then click on "Filter Data" button. It will remove the filter mode and will remove the data from Col B as well.


4) You can check the macro by pressing ALT+F11 from your keyboard (to bring the code module)[Module1 contains the code]


Hope this helps.


Kaushik
 
Jason, technically you stole my name first. Otherwise I wouldn't have had to pick a pseudonym. :)


Thanks to both you and kaushik. Both very informative and helpful posts!
 
You must log in or register to reply here.
Back
Top