I made this site so that I'd be able to reference code snippets later. If you're able to view this then hopefully you can benefit too. Feel free to email questions.

-T

---

Excel & VBA

• Know your VBA datatype
• Keeping your Excel file's size small 
• Merged cells alternative

SQL Related

• CountIfs (Excel) equivalent using sum and case when