Well we are trying to fetch some data using excel filters. But we are unable to apply filter simultaneously on two excel columns. The problem is explained in the attached sheet. If you have any query/doubt in understanding the whole problem then writ it.
something like this?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
its showing only the top rows for both Ram and Atish. I want that it should show all the cells containing Ram if we select Ram in filter. And it also should show all the cells containing Atish if we select Atish in filter.
Ok, see, try this one instead, it requirs a helper column.
EDIT: just use the text filter and contains, it appears to give you what you want.
well your suggestion is working up to great extent......
will edit it as per requirement
thanks alot for it....
Great! If that solves your issue don't forget to mark the post as solved. And I'm not averse to having my reputation bumped if I helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks