Category: Excel

Excel 2010 doesn’t have an XOR function. The newer versions do. I have needed this form of logic a couple of times recently and I found a good tip here. XOR works like this. A B Result 1 1 0 1 0 1 0 1 1 0 0 0 So, if you don’t have an…

This is to remove excess characters from a string. It can be enhanced with options or changed depending if you want spaces or not etc. Function fixchar(s As Variant) As Variant Dim a, b, i As Integer fixchar = “” If Len(s) = 0 Then Exit Function For i = 1 To Len(s) b =…

I’m always forgetting the syntax and also here’s some tricks. How to highlight cells based on another cell’s value in Excel 2011 – Ask Different Format cell color based on value in another sheet and cell – Stack Overflow Conditional format cells based on match in another sheet – Stack Overflow

How to VLOOKUP with Multiple Criteria Using INDEX and MATCH in Excel

Directory Tree Builder Add-In for Excel. DirTree will create a tree-like hierarchical list of all the folders and (optionally) files contained within a specified directory. When you load the Add-In, an item with the caption Build Directory Tree is created on your Tools menu. When you click that item, the Directory Tree Configuration screen, described…

Function revstr(s As String) As String ‘ ‘ revstr Macro ‘ revstr = “” If s = “” Then Exit Function For j = Len(s) To 1 Step -1 revstr = revstr & Mid(s, j, 1) Next End Function