Hi guys,

Would like any excel experts here regarding advance filtering.

Here's a sample excel sheet that I've uploaded with some filtering
insturction included.

http://s33.yousendit.com/d.aspx?id=2...P2846UUVJ49GTO

( no virus don't worry)

Thanks again.

Andrew

Why is item 1 A (K14:L14) present in filtered list?
According to rule #2, it should not (ID = A)

BTW, this will probably need some VBA code. Do you mind?

Yours,

--
AP

a écrit dans le message de
oups.com...
Hi guys,

Would like any excel experts here regarding advance filtering.

Here's a sample excel sheet that I've uploaded with some filtering
insturction included.

http://s33.yousendit.com/d.aspx?id=2...P2846UUVJ49GTO

( no virus don't worry)

Thanks again.

Andrew

Personally, you may tell me no virus but that is meaningless. You don't even
say what the problem is. Describe it in words, everyone else does.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
Hi guys,

Would like any excel experts here regarding advance filtering.

Here's a sample excel sheet that I've uploaded with some filtering
insturction included.

http://s33.yousendit.com/d.aspx?id=2...P2846UUVJ49GTO

( no virus don't worry)

Thanks again.

Andrew

I eventually understand rule #3, which explains why 1A remains in filtered
list.

I already have a solution with rules #1 & #2. Rule #3 is tricky to
implement...

"Ardus Petus" a écrit dans le message de
...
Why is item 1 A (K14:L14) present in filtered list?
According to rule #2, it should not (ID = A)

BTW, this will probably need some VBA code. Do you mind?

Yours,

--
AP

a écrit dans le message de
oups.com...
Hi guys,

Would like any excel experts here regarding advance filtering.

Here's a sample excel sheet that I've uploaded with some filtering
insturction included.

http://s33.yousendit.com/d.aspx?id=2...P2846UUVJ49GTO

( no virus don't worry)

Thanks again.

Andrew