Auto filter

I have 3 columns in excel. I want to apply filter on column 1 but have the flexibility to filter column 2 independently or not filter it at all. Right now when I apply filter it goes to the column 2 as well. for example if I select a value in column 1 through filter it shows in column 2 only those values that correspond to the values selected in column 1

Thanks
camper12Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RayData AnalystCommented:
Assuming your data is in rows on purpose because they are related (IE, first name, last name, zip code), then why would you ever want it to do what I THINK you're asking. The premise of excel and filters is that data in rows belong together.  So you either want to see the 'row/entry' in it's entirety or not at all.

The answer to your question is that filtering will hide/show only the entire rows based on the filter criteria.  There is no way around that.

Perhaps more information on your ultimate goal might help provide a response to meet you needs?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
camper12Author Commented:
Thanks Ray. The columns are not related. If I select value A in column 1 then for any value in column 2 it should return something. basically an OR between the two columns.
0
RayData AnalystCommented:
Can you post an example file please?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

camper12Author Commented:
A      B            A      B      C
HJ      4            HJ      6      TRUE
JK      3                        
MN      7                        

A and B are my two columns based on which C is determined. I want the user to select multiple values under A using the filter. The user can also select multiple values from B using the filter. I want to then populate under A B and C the values that user selected. C will have something like this:=OR(D2:D10="HJ",E2:E10=4)

Thanks
0
camper12Author Commented:
I think I should make a dropdown that helps user select multiple values. Then access these selected values and find C.
0
Roy CoxGroup Finance ManagerCommented:
To filter the Columns independently you can add a empty column between each column
0
RayData AnalystCommented:
Roy, if you filter a column (at least in Excel 2013) it filters the entire row regardless if you have an empty column (or columns) or not.  If there is some setting where you can change this behavior, then that information would be helpful (but it is not the default setup).

Camper, I'm sorry but I'm still not following what you're trying to accomplish.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.