Tips, Tricks, and Techy Tidbits

I’m always on the lookout for well written Excel tips for crunching large amounts of data.  Seems many of the litigators I know need to analyze large datasets.  Allen Wyatt’s ExcelTips Online is a terrific resource.  He offers a weekly e-mail newsletter, and 2 RSS feeds - Daily Nuggets and the Weekly Classic.

Check out this tip - Deriving Monthly Median Values - the example looks at sixty years worth of data and offers two strategies for finding the monthly median value.  He explains as he goes, which makes his tips even more valuable.  I believe you could take this tip and run with it to suit your needs.