Simple Question i am still thick

[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

 

[Frank Kabel]

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

 

[Aladin Akyurek]

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.