If you have Microsoft Office 2016 and are having crashing, freezing issues (mainly with Word or Outlook), 99% of the time it's due to not getting Office updates. Especially if you bought the office suite with your computer. UPDATE: If you have ANY other version of Office installed (Ex: Office 2010, 2013, etc.) this is…
Read more
Excel – Lookup value in column and return value from another column
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
Excel – How to return the column letter of cell reference
Here is an excel formula to return the column letter of the refereed cell; this one extends to AA, AB ......---> to end: =LOWER(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")) - small letters or =SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") - caps
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