StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POExcel 2003 Advanced Filer
text
Body
copied!<p>I have These value also in the worksheet:</p> <pre><code>Cell location Value A1 Today() B1 =TEXT(A1,"dddd") G3 Day H3 Day I3 Day G4 D H5 =LEFT(B1,3) I6 x </code></pre> <p>Now start from A3 to D19</p> <pre><code>Book Name Code QTY Day .Net x Book1 NBC 2 Mon Book2 NAA 1 Wed Book3 NBA 3 Tue/Mon Oracle x Book1 OB1 1 D Book2 OXZ 1 Fri Book3 OPS 2 Sun Book4 OPR 1 Thu Java x Book1 JPS 1 D Book2 JJJ 4 Sat PHP x Book1 PMW 3 Wed/Tue Book2 PHY 2 D Book3 PED 1 Fri </code></pre> <p>Today is Thursday and when I open the workbook its view should be like this:</p> <pre><code>Book Name Code QTY Day Oracle Book1 OB1 1 D Book4 OPR 1 Thu Java Book1 JPS 1 D PHP Book2 PYH 2 D </code></pre> <p>I have mention x as day for category of the books because I want category name row in the view also.</p> <p>Means all rows who have D (Daily) in day column and first three char in the day column whether they are Thu or /Thu (for Thursday example).</p> <p>I have done it by VBA :</p> <pre><code>Private Sub Workbook_Open() Range("A3:D19").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _ Range("G3:I6"), Unique:=False End Sub </code></pre> <p>But it is giving me below view:</p> <pre><code>Book Name Code QTY Day .Net x <---Not required Oracle x Book1 OB1 1 D Book4 OPR 1 Thu Java x Book1 JPS 1 D PHP x Book2 PHY 2 D </code></pre> <p>I don't want above mentioned rows because there are no books for today or nor they are in daily view.</p> <p>Kindly let me know, I am clear in my question or provide more details please.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload