Professor Excel

Hyperlink: 3 Ways of How to Extract the Link from an Excel Cell

Sometimes, you copy webpages. Or just a links. Or you receive an Excel sheet with links in it. In such case, you often want to extract the hyperlink addresses from the cells. There are basically just three options for getting the hyperlink address from an Excel cell.
[…]

minif, maxif, minifs, maxifs, formula, excel

MINIF & MAXIF: 5 Ways to Get a Conditional Minimum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to return the minimum using a simple example. We got an Excel table with two columns “Car type” and “Price”. We want to know the minimum price for each car type. Sounds easy? Unfortunately, Excel makes it unnecessarily difficult to calculate.
[…]

record, vba, macros, excel

VBA Macros in Excel: How to Record, Edit and Run Them

With VBA macros, you can do many things which aren’t possible using the build in Excel functions. You can save a lot of time by using macros, especially with repeating tasks.

How to Get the Name of an Excel Worksheet

Often, you need to display and work with the sheet name, for example if you are working with the ‘INDIRECT’-formula. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to get a sheet name:
[…]