View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vijaydsk1970 vijaydsk1970 is offline
external usenet poster
 
Posts: 47
Default Conditional Filtering

I have an excel sheet contains all the customers in once column "a" and their
monthly sales in column "b,c,d,e,f,g,h,i,j,k,l,m" and average in "n".
I want to filter all the customers whose average is 0 and less than 50
sales and another condition is 50 and less than 100.
Kindly advise me any formula, so that i can filter all the above said
customers and put them in an other sheet.

Thanks in advance.