Simple Question i am still thick

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

In an advance filter or in a dcount is there any way of writing a
criteria in a single cell which is an or statement. My issue is that I
have 8 multiselect listboxes which need to combine to form a single
criteria. Each list box can have 10 or more items in it, all of which
can be chosen.

Hence an easy way of combining would be using an "or" statement

does anybody know how
 
Hi
not possible in a single cell if I understood you correctly but you
could try something like the following:
=SUMPRODUCT(--(A1:A1000={"crit1","crit2","crit3"}))

to count all occurences there one of the three criteririas in column A
is met
 
Given

{"X","Y";"a",4;"b",3;"c",2;"a",4;"d",6;"e",3}

in A1:B7, would the Criteria range F1:F2 express an OR-conditional with

F1 empty

F2 housing:

=ISNUMBER(MATCH(A2,{"a","b","c"},0))

You can also have a range for the {"a","b","c"} bit, say, G1:I1.
 
Back
Top