Hello!

I have data in three columns: A,B,C and each columns has several rows with numbers.

I want to return all the A numbers that match:

B= 4 or 3

AND

C = 5

Any idea?

I have been browsing through several websites but most at horrible in explaining bit by bit the formulas.

Thanks!

I have data in three columns: A,B,C and each columns has several rows with numbers.

I want to return all the A numbers that match:

B= 4 or 3

AND

C = 5

Any idea?

I have been browsing through several websites but most at horrible in explaining bit by bit the formulas.

Thanks!

Last edited: