Leave a Cell Blank if the Condition Is False
The following formula will check cell A1, and if the condition is False (value != 2) it returns blank, otherwise (value = 2)…
Category: formulas
Check if Value Exists in Another Column Using VLOOKUP
In order to get the value from the cell next to the matching cell, you have to use the vlookup function. This function…
Sumproduct
The SUMPRODUCT function is the combination of addition (SUM…) and multiplication (…PRODUCT). It gets one or more arrays and returns the sum of products of…
Timestamp in Excel
When you work with Excel, sometimes you may want to enter the current date or time near the list of items, such as…
Remove Leading and Trailing Spaces
There are a few different ways you can use to clean imported data from unwanted leading or trailing spaces. In this lesson, I…
Remove Blank Rows in Excel
If you have a large list containing empty rows, dealing with each row manually may not be the best idea. For that reason,…
Add Leading Zeros in Excel
When you create a form you may want to include zeros in front of the number. For example 000123 But after you enter…
Highlight Duplicate Rows in Excel
Depending on the data you have in your worksheet you may use one of the following ways to highlight duplicate rows. Highlight duplicate…
Excel if statement
In situations where the result is based on criteria, you can use the IF statement to return one result if the condition is TRUE and…
Get Column and Row Numbers in Excel
Row numbers are easy to identify because they use numbers on the left side of a workspace. So even if you use a…