MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Advanced/Auto Filter for rows


Posted by David Crowell on February 14, 2002 10:04 AM

I have Month column headings going across row 4 of my worksheet and G/L accounts in column A. I would like a Filter or List box that would show detail of the selected month. Two filters would be ideal to run a comparison of two selected months. Please let me know if this is possible or if a pivot table would provide better results. Thank you for your help.


Posted by Mark W. on February 14, 2002 12:42 PM

Rule #1 of Excel List design...

Don't know who's responsible for the maintenance
of Excel and VBA help files, but can't disagree
about the presence of errors. In fact, just the
other day I found a discrepancy in the help file
for TRIMMEAN.

I'd supplement the help files with a couple of
other techniques....

1. After selecting the function and its complete
argument list (including parentheses) in the
formula bar, use F9 to see what the function is
returning.

2. After typing a function without its argument
list (e.g., =EXACT) press Control+A and examine
the suggested argument data types.

Posted by Mark W. on February 14, 2002 1:06 PM

Darn it! I wrote a lengthy response and this web site replaced it with the unrelated posting below!!! [nt]

Posted by Mark W. on February 14, 2002 1:10 PM

Shortend version of "Rule #1 of Excel List design..."

You data list design isn't optimal for PivotTables.
Data lists should be in 1NF (1st Normal Form) which
means no repeating groups. You have a repeating
group of account data (balances?) indexed by Month.

Instead of...

Account Jan Feb Mar...

Use...

Account Month Balance

...as your headers.