Monthly Archives: September 2013

Pivot Table Sort is Too Clever

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

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

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

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