View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default IF AND Statement Needed

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.