This is the first post in a series where we’ll talk about how to use the FILTER function as an alternative to lookup functions including VLOOKUP. Why? Well, as we’ll discover in this series, the FILTER function offers several key benefits. For example, FILTER supports: Multiple return columns Multiple lookup columns Multiple matching row values In this first post, we’ll see Read More
Month: November 2021
Features Comparison: Azure SQL Database and Azure SQL Managed Instance
APPLIES TO: Azure SQL Database Azure SQL Managed Instance Azure SQL Database and SQL Managed Instance share a common code base with the latest stable version of SQL Server. Most of the standard SQL language, query processing, and database management features are identical. The features that are common between SQL Server and SQL Database or SQL Managed Read More
Upwork vs. Fiverr: Which Freelance Job Site is Best?
We take a deep dive into freelance service platforms, and here we look at key differences between Upwork vs. Fiverr. By Lena Borrelli Remote work is increasingly taking off as technological developments continue to change and shape how we live and, more importantly, how we earn. Freelance job sites have become a new lifeline to both Read More
How to Filter Out Multiple Criteria Using Excel VBA
Questions: I have 8 variables in columns A, 1,2,3,4,5, and A, B, C.My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But what the code does is filters variables 1 to 5 and display them. I want to do the opposite but yield Read More
Understand What is Retire / Wipe / Delete / Fresh Start / Autopilot Reset in Microsoft Intune
It feels there are a million different reset options in Microsoft’s endpoint manager (aka Intune). Some of the options even provide additional „suboptions“. I would like to explain the different options, their differences, and their main use cases here. If you prefer it short and concise summary can be found at the end. Retire/Delete Let us get Read More
How to Add a Custom Link as a Menu Item in WordPress
Use the Custom Links panel to add a custom link to your menu, such as a link to an external website. Simply type in the website URL in the URL field and the menu name in the Link Text field. Click the Add to Menu button when done. Use the same steps outlined previously to adjust the order of the menu item and Read More