View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yookaroo Yookaroo is offline
external usenet poster
 
Posts: 10
Default Extracting Rows based on a number in a field

I have columns L to AZ that may or may not contain the number 41, I need to
extract all of the rows that have the number 41 somewhere in them, and make o
seperate files one with and one without rows with 41?

Any help would be appreciated

Columns A to K have address data, that I hope can be excluded from this as
some addresses may have 41, but I can live with manually removing them if I
need to.