• 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

N

niting

New Member
hie forum,


I have a worksheet with 15 columns and 5000 rows.


I have to apply filter on 2 columns specifically wherein if either of them has a number<>0, the other column should also show even if the value is 0 and the other relevant columns corrosponding to it.


When I apply filter on one column for values, then it shows values for that column. However, i am not achieve the result as desired(mentioned above).


Do I have to manually apply filter on both one by one and then copy the data to other sheet, or is there a better way out.


Thanks

Niting
 
Hey


Have you tried using custom sorting? there you can put several arguments for filtreing, it is available on the sort & filter drop down icon, shortcut in 2010 is 'Alt,H,S,U'


cheers
 
Niting


What about adding a helper Column

Which will have a formula to setup a suitable value which you can filter on

eg: =If(And(e1>0,Or(c1<>0,d1<>0)),True, False)


Can you be more specific with what conditions you want?
 
Thanks Hui,


After the post, I also thought that I could use the helper column and use it on Monday in the office. Your post just put any doubt in my head to rest.


Thanks again.
 
You must log in or register to reply here.
Back
Top