When making references to a range from one Google Sheets into another Google Sheets, you will need the Google Sheets IMPORTRANGE function. If you need to count the occurrences of a certain string of characters or any cell content that meet certain criteria, you may need the Google Sheets COUNTIF function. Combining the two formulas gives you the superpower of counting over an external range based on a criterion. However, there is a catch!
Where Can I Learn Regular Expressions Syntax and Use? Regular expressions are fun, if you can figure out how to use use them of course.… Read More »Where Can I Learn Regular Expressions? How About Testing?
If you are a MacOS user, you most likely have a pop up message on your mac recently stating, “This app will not work with… Read More »What Does It Mean That “App” Is Not Optimized For Your Mac?
SharePoint is under attack as attackers have discovered and are exploiting vulnerability CVE-2019-0604. Find out more about the vulnerability in the linked security advisory by… Read More »Microsoft SharePoint Under Attack – CVE-2019-0604
Windows has a really cool tool you will be glad to discover if, like me, you like to have lots of power on you computer.… Read More »What Is This So Called God Mode on Windows and How Do I Access It?
The answer is yes if keeping passwords in plain text is considered secure. The obvious answer is NO. No, Facebook has failed you once again.… Read More »Is Facebook Keeping Your Password Secure?
According to a report this morning from SonicWall, a vulnerability that could allow remote code execution has been discovered in WinRAR. This software vulnerability exposes… Read More »Critical Vulnerability in WinRAR Exposed – Absolute Path Traversal
On Windows 10, using the Windows Management Instrumentation Command Line (WMIC), you can set the password never to expire with the command: WMIC UserAccount WHERE… Read More »Windows 10 Command Line – How to Set Password Never to Expire
Facebook published this October 12, 2018 an update on the attack that we presented to you just about two weeks ago in an article titled Facebook… Read More »Update On The Facebook Hack – Are You One Of The 30 Million Users Who Got Hacked?