Graycar's Folly

2-1-2-a Method in Action : for sorting, the easier way is to just use Format as Table - and then you get the filter buttons for free..

And, like M$, Hal hints at the usefulness of the INDIRECT function.

Wrong again Lord Graycar, that's not how traffic lights look :) It's 3 separate light sources didn't ye k?

When it comes to importing data from a website - like the Shark Watching thing - this is an example of teaching people bad habits. This is text processing. The right thing to do is use perl.

As for highlighting the max value - an early module suggested using top-1-percent -- which is kind of lame don't you think? Why not use MAX(NamedRange)?

Yikes, how about forgetting to tell us how to accept Excel's suggestion while typing? If it's only one suggestion, use the TAB key.

Good stuff : Make Once, Use Many. Also, nice stuff on Dynamic Charting. Knowing the stuff that you may never use to build the things he's built will still help you accomplish some of your goals.