Hi,
I would like one page where I can specify certain criteria and return a list of all the rows that contain those criteria, essentially a large VBA Query Filtering masterpage.
I've attached a scrubbed excel below (in a post below titled TEST3).
Essentially you'll see 4 tabs, List1, List2, List3, and List4. Each list has the same columns but different rows with various types of info according to 4 sections of our business (again scrubbed).
Essentially I would like the master sheet to have drop downs or checkoff lists that search List1, List2, List3, or List4 (and place that result in a new column), and then search a custom filter for Y, N, N/A, answers from Questions 1 to Questions 8, which are essentially column O to Column W (skipping column S) and then where you can simply click a button and it returns all the rows but only columns J to AE in that newly created master tab (along with a new column that shows List1, List2, List3 or List4 as a name. If this last part is too complex then we can remove.
So we will want to filter based on data in Columns O-W, but the caveat is that we need OR and AND functions to be appropriately placed in the VBA/search criteria:
o Y in either (O or T) AND Y in either (R or W)
o Y in either (P or U) AND Y in either (R or W)
o Y in either (O or T) AND N in either (R or W)
o Y in either (P or U) AND N in either (R or W)
o N in either (O or T) AND Y in either (R or W)
o N in either (P or U) AND Y in either (R or W)
o N in either (O or T) AND N in either (R or W)
o N in either (P or U) AND N in either (R or W)
So some kind of checkbox or dropdown that can account for filtering for these WITHOUT excluding them on accident.
Best,
Original Post:
Hi,
I'm trying to filter data based on OR and AND criteria. I thought AutoFilter would simply do it but it doesn't show what I need.
To keep it simple:
I have 10,000 rows of instances, and each instance has 4 columns with questions that answer either YES, NO, or MAYBE. I want to filter and show all the rows that say "YES" in columns 1 OR 2, and that say "NO" in columns 3 AND 4.
Basically how do i incorporate the OR and AND functionality.
Thanks
Bookmarks