Advanced Filter Help!!!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jkramos2005 - 27 Aug 2008 22:41 GMT

Hi,

I have the following data table:

Plant Acct July Aug Sep
Oct Dec

Lincoln 000.01000 0 0 0
25 -25
Lincoln 000.01100 0 0 0
0 0
Lincoln 000.01200 25 97 69
0 5

Is it possible to use the Advanced Filter function in excel to look at each
month for each line and omit lines that have zeroes for all months and copy
to another area lines that have data for the six months. Whether it be data
in just one month or if the data zeros out at the end of the year. I want
to be able to capture that fluctuation through the year.

Any help would be most appreciated.

Thank you in advance.

Reply to this Message

CyberTaz - 28 Aug 2008 12:28 GMT

If I understand correctly: In the Criteria Range use <>0 for each month but
on separate rows. For example, if the Month captions in the Criteria Range
for July-Dec occupy M1:R1 put the <>0 in cells M2, N3, O4, P5, Q6, & R7. Be
sure to specify the entire set of rows (say H1:T7) as your Criteria Range.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 8/27/08 5:41 PM, in article
A5C6A463-3115-41CD-902D-C6C892897684@microsoft.com, "jkramos2005"

> Hi,
>
[quoted text clipped - 19 lines]
>
> Thank you in advance.

Reply to this Message

Mac Forum / Applications / Excel / August 2008

Advanced Filter Help!!!!!