View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NeedExcelHelp07 NeedExcelHelp07 is offline
external usenet poster
 
Posts: 30
Default Filter a range of data with multiple criteria

I have a worksheet with about 4000+ users (rows).
I need to filter out the data containing one of the four codes starting with
A,D,L, or R.
How can I create a formula that will search for the codes in the column
starting with the above letters and return a TRUE if it is there and a FALSE
if it is not.
There are 8 columns per row. I just need to search in one column for the
above text.

Thanks!