You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more
Unprotect an excel sheet without password
If you have ever protected an excel sheet; forgot the password or got a excel sheet and needed the password to edit it, here is how to "unlock it": http://uknowit.uwgb.edu/page.php?id=28850 Here is the VBA code that you will need to crack and show you the password: Sub PasswordBreaker() 'Breaks worksheet password protection. Dim…
Read more
Adobe Premiere cache folder cleanup
I ran into a disk space problem today with Adobe Premiere. Basically the application creates a media cache when it imports media and that media cache seems to default to the system drive in the user Library folder. This cache can balloon in size over a period of time. After some Googling I found this…
Read more
Display code snippets in your WordPress Posts
A good plugin to use if you are wanting to display code snippets in your post is SyntaxHighlighter Evolved. It will very nicely display: PHP, MySQL, HTML, etc... code in a nicely formatted code box. Setup only takes about 30 seconds, than for immediate basic usage just warp any code you want in <pre> </pre>…
Read more
Backscatterer Network Spam List
Has your e-mail server ever been blacklisted? Or are you getting rejected emails? A good first step is to check MxToolBox too see if you ARE indeed blacklisted. Now, if you see one called "Backscatterer.org" you are in trouble, read this to see why. Basically, "As it turns out Backscatterer is NOT a blacklist, It's…
Read more