Monthly Archives: September 2013

Pivot Table Sort is Too Clever

Posted on September 23, 2013 by fastexcel

I created a pivot table from a list containing 3 character IDs, then used the Pivot Table field pulldown to sort it. The resulting sorted list looks like this: Looks like Pivot Table sort recognises 3 character abbreviations for The … Continue reading →

Posted in Uncategorized | 6 Comments

Finding missing items in lists: VLOOKUP vs COMPARE.LISTS performance and ease of use

Posted on September 19, 2013 by fastexcel

Returning to the subject of finding the missmatches between 2 lists I want to compare using VLOOKUP with using SpeedTools COMPARE.LISTS. Test Data My test data consists of 2 lists of 500000 6-digit numbers. Most of these numbers match, but … Continue reading →

Posted in Calculation, Lookups, UDF, XLL | Leave a comment

Custom Excel Worksheet Templates in Departmental Solutions – Pros and Cons

Posted on September 18, 2013 by fastexcel

Excel allows you to create and use custom workbook and worksheet templates (you can also change the default workbook and worksheet templates). This post explores the pros and cons of using custom Templates in the sort of general purpose departmental … Continue reading →

Posted in Calculation, Uncategorized, VBA | 2 Comments

Catchup Post

Posted on September 17, 2013 by fastexcel

The blog has been quiet for too long … That’s because I have been too busy with a large customer project and summer activities. This summer after 32 years we decided to sell our lovely Norfolk holiday cottage: and downsize … Continue reading →

Posted in Sailing, Uncategorized | Leave a comment