formulas Archives | Page 15 of 17

Add Text to Date Cell in Excel

In order to add text to date in Excel, enter the following formula. This formula adds date formatted as text into the cell….

The are many methods you can use to remove duplicates and keep only unique values. In this lesson I’ll show you 4 ways,…

Usually, the #N/A error appears when you deal with lookup functions, such as VLOOKUP, HLOOKUP, LOOKUP, and MATCH. If you encounter this error,…

If you want to return the cell address or cell value by specifying a row and column, you can do it by using…

Dates in Excel are displayed as dates, but in reality, they are numbers formatted in a way that is easily recognizable by people….

Let’s say that we have three columns. The first column consists of user ids (A), the second column has a corresponding name (B),…

Let’s say that you have a formula with cell references. Normally, if you drag them, all cells will change accordingly. Let’s take a…

There are a few methods to apply the formula for the rest of the cells in a column that the formula should be…

Case insensitive In order to check whether a cell contains a substring in a text, use the following formula.

=ISNUMBER(SEARCH(substring,string))

1	=ISNUMBER(SEARCH(substring,string))

The following formula…

In order to count unique values in the Pivot Table, you have to do the following steps.

=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1)

1	=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1)