Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Filtering | Excel Worksheet Functions | |||
conditional if or filtering in pivot table | Excel Worksheet Functions | |||
how do I maintain my conditional formatting when filtering cells? | Excel Worksheet Functions | |||
Filtering out text with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Filtering | Excel Worksheet Functions |