Showing related tags and posts accross the entire site.
-
This ties a little to zfraile's post on faster lookups but most definatlely applies ONLY to unsorted lists. In this environment specifying a sorted list is not an option. A lot of our workbooks use Vlookups extensivley but the recalculation times are starting to suffer. So I started combining MATCH...
-
This workbook has a sheet of each type available in Excel. if you click on the 'Create Index' button, it adds a worksheet with the worksheet name, type and, if possible, a hyperlink to that sheet. It just a file by way of VBA demo. (Alt+F11 to look at code)