How to Select Every Other Cell in Excel (Or Every Nth Cell)
If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …
Formulas
SUMPRODUCT vs SUMIFS Function in Excel
The SUMPRODUCT function was always the go-to function for finding conditional sums, till the time SUMIFS was introduced in Excel 2007. A lot of people shifted to using SUMIFS instead …
How to Auto Format Formulas in Excel (3 Easy Ways)
When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …
How to Extract URL from Hyperlinks in Excel (Using VBA Formula)
If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …