For future reference:
Consider a data range from A1:C22, with headers "Buyer", "Seller", and "Quantity" in cells A1, A2, and A3 respectively. Traders are Alan, Barry, Christina, Deborah, Evan, and Gwen. (Sample file here.)
For simple advanced filtering I would put "Buyer" and "Seller" in cells
A25 and B25 (or where-ever) as the top row of my criteria range, with my
conditions below. E.g., (Buyer=Alan) AND (Seller=Barry) would be
A26: ="=Alan"
B26: ="=Barry"
For (Buyer=Alan) OR (Seller=Barry), the conditions go on separate rows:
A26: ="=Alan"
B27: ="=Barry"
For (Buyer=Alan OR Barry OR Evan) AND (Seller= Christina OR Deborah OR Gwen), I need to replace my headers in the criteria range: "Buyer" and "Seller" become "Condition1" and "Condition2". Then:
A26: =OR(A2="Alan",A2="Barry",A2="Evan")Where "A2" and "B2" are the cells at the top of the columns in my data range containing the data to which the conditions are to apply.
B26: =OR(B2="Christina",B2="Deborah",B2="Gwen")
I.e. The first condition (in A26) relates to the buyers, and the buyers are the column A. Cell A1 is the header, so the OR formula refers to cell A2.
Solution originally from Microsoft Answers.

No comments:
Post a Comment