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)

"vijaydsk1970" wrote in message
...
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.

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

"Bob Phillips" wrote:

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)

"vijaydsk1970" wrote in message
...
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.

See http://www.contextures.com/xladvfilter01.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"vijaydsk1970" wrote in message
...
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

"Bob Phillips" wrote:

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)

"vijaydsk1970" wrote in message
...
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.