If

Column A = Unique Customer ID
Column B = Email Address
Column C = Product/Plan's held by customer (each of which is separated
by a ; could be one could be 50)

I want to query column C -

IF C contains ('Biz 1'*'Biz 2'*'Biz3'*'Biz4'*'Biz5'*'Biz6'*'Biz7')+
('Phone 1'*'Phone 2')

or

(at least one Biz 1 - 7 plan) AND (at least Phone 1 or Phone 2)

then list contents of Column A and Column C in a separate spreadsheet
(per line/Ctrl-Shift-Enter)

Hope this makes sense, any idea's friends?

What did I do so wrong that no one so much as attempted to help a
brother out!?

On Jun 30, 8:50*pm, Mike wrote:
If

Column A = Unique Customer ID
Column B = Email Address
Column C = Product/Plan's held by customer (each of which is separated
by a ; could be one could be 50)

I want to query column C -

IF C contains ('Biz 1'*'Biz 2'*'Biz3'*'Biz4'*'Biz5'*'Biz6'*'Biz7')+
('Phone 1'*'Phone 2')

or

(at least one Biz 1 - 7 plan) AND (at least Phone 1 or Phone 2)

then list contents of Column A and Column C in a separate spreadsheet
(per line/Ctrl-Shift-Enter)

Hope this makes sense, any idea's friends?