advance filtering

[andrew77]

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=2X7QJ2GX7YDRP2846UUVJ49GTO

( no virus don't worry)

Thanks again.

Andrew

 

[Ardus Petus]

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,

 

[Bob Phillips]

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)

 

[Ardus Petus]

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...