Conditional Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Just add the average to a separate column, =AVERAGE(B2:M2), and then filter
that column by your criteria

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Thanks Bob Philips,
But my work sheet contains average column "n" hope i dont need the formula
what you suggested. and an other thing the formula what i am asking is, it
should filter (on the said condistions) from existing data and copy them into
another sheet
 
Back
Top