Hello,

I have 10 columns, AK to AT, that have codes in them. Each column contains
the following codes: A0, A1, A2, A3, A5, A6, A7, A8, 49, 51, 52, 53, 54, 58,
60, 61, 70, 87, 88. I only want to keep the records (rows) when they have
any of those codes in any of the ten columns. I think I need an IF AND
statement. How should I write it?

Thanks.

=SUMPRODUCT(COUNTIF(codes,AK2:AS2))

Auto Filter the "0s" and delete them

"Daren" wrote:

Hello,

I have 10 columns, AK to AT, that have codes in them. Each column contains
the following codes: A0, A1, A2, A3, A5, A6, A7, A8, 49, 51, 52, 53, 54, 58,
60, 61, 70, 87, 88. I only want to keep the records (rows) when they have
any of those codes in any of the ten columns. I think I need an IF AND
statement. How should I write it?

Thanks.

Thank you! That worked.

"Teethless mama" wrote:

=SUMPRODUCT(COUNTIF(codes,AK2:AS2))

Auto Filter the "0s" and delete them

"Daren" wrote:

Hello,

I have 10 columns, AK to AT, that have codes in them. Each column contains
the following codes: A0, A1, A2, A3, A5, A6, A7, A8, 49, 51, 52, 53, 54, 58,
60, 61, 70, 87, 88. I only want to keep the records (rows) when they have
any of those codes in any of the ten columns. I think I need an IF AND
statement. How should I write it?

Thanks.