All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Would like to know how use the filter in excel with AND instead of OR So filtering three columns with a 0 and 1 and asking that all three show up if at least one has a number 1
Solved by B. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 26/07/2017 - 08:50
Hello! Thanks for choosing Got It Pro-Excel.
Excelchat Expert 26/07/2017 - 08:52
Well, do you have any available data for doing this filtering of 3 columns?
Excelchat Expert 26/07/2017 - 08:52
hello
Excelchat Expert 26/07/2017 - 08:52
p there?
Excelchat Expert 26/07/2017 - 08:55
At this time, I need to assume that you will be looking for the solution on this issue
Excelchat Expert 26/07/2017 - 08:58
Now we can continue into the explanation step of this session. I am going to perform the filtering of data using OR function instead of AND
Excelchat Expert 26/07/2017 - 08:59
Well, here's a link for you to study about filtering such data
Excelchat Expert 26/07/2017 - 08:59
https://support.office.com/en-us/article/Filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e
Excelchat Expert 26/07/2017 - 09:00
Also, please watch this video for demonstration
Excelchat Expert 26/07/2017 - 09:00
https://www.youtube.com/watch?v=OzWzp1i52PI
Excelchat Expert 26/07/2017 - 09:02
Hopefully, this link I've shared will make sense.
Excelchat Expert 26/07/2017 - 09:02
Is there anything else you want to know regarding this issue?
Excelchat Expert 26/07/2017 - 09:03
Well, Thank you for coming at Got It Pro-Excel!
Excelchat Expert 26/07/2017 - 09:03
Have a good day ahead!
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc