Use Conditional Formatting On Errors in Excel
Applying conditional formatting on errors in Excel can help you quickly and easily identify cells that contain errors in a large dataset. Different…
Author: Christopher Sirali
Lock Data Validation in Excel
Locking data validation in Excel is useful to prevent users from changing or deleting the data validation rules you have applied to a…
Find Column Index Number Using VLOOKUP in Excel
In Excel, we can use the VLOOKUP function to find a table’s column index number of a specific value. This tutorial shows how…
Consolidate Multiple Ranges into One PivotTable in Excel
You can create a PivotTable in Excel based on data ranges from worksheets in a workbook or other workbooks, provided the datasets have…
Use SUMPRODUCT and COUNTIF together in Excel
SUMPRODUCT and COUNTIF are two powerful functions in Excel that can be used together in formulas to perform various calculations, for example, return…
Sum and Ignore Errors in Excel
You can use the SUM function to add a range of cells in Excel. However, if some cells in the cell range contain…
Zoom in and Out of Worksheet in VBA
You might want to zoom in and out of a worksheet using Excel VBA for several reasons. For example, if you have created…
Use VLOOKUP and INDIRECT Functions Together in Excel
You can use the VLOOKUP and INDIRECT functions together in Excel to look up a value in a table in a different worksheet…
Highlight Rows Based on Drop Down List in Excel
As we work with Excel, we may want to highlight rows in a dataset based on the selection on a drop-down list in…
Generate Random Numbers in VBA
Generating random numbers in Excel VBA can be helpful in different scenarios. For example, to create a random list of numbers for statistical…
