Share

Hide #DIV/0! From Excel Pivot Table

• On: July 10, 2014
• 3 Comments

Conditional formatting #DIV/0! within Excel is easy enough, but that doesn't ...

Share

Create CSV from file names in Windows folder

• On: July 6, 2014
• 0 Comments

I have several hundred files in a windows directory that I ...

Share

Find the datatypes of a SQL #temp table

• On: July 4, 2014
• 0 Comments

I'm sure you've done it a million times like I have: ...

Share

Excel Lookup – Maintain Date Format

• On: July 1, 2014
• 0 Comments

Consider the following spreadsheet in Excel: I wish to perform a ...

Share

Sort In Original Order When Grouping

• On: June 26, 2014
• 0 Comments

I am working on analysis against the Soccer World Cup in ...

Share

Get First Day & Last Day of Last Week

• On: June 24, 2014
• 0 Comments

I have a requirement to generate data for reporting for the previous ...

Share

Find all tables with specific column name

• On: May 25, 2014
• 0 Comments

Ever need to find out if or where a column exists ...

Share

Goodbye Solutions Outsourced

• On: May 19, 2014
• 0 Comments

After two years and a few months it was time to ...