How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

How to combine text or data from two or more cells into one cell in Excel.

Let's look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it's time to use another tool in your Excel arsenal. Following is an example of …

Use the ampersand (&) to join, or concatenate, one or more text strings to produce a single piece of text. Connects, or concatenates, two values to produce one continuous text value. Combine …

You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.

Excel follows general mathematical rules for calculations, which is Parentheses, Exponents, Multiplication and Division, and Addition and Subtraction, or the acronym PEMDAS (Please …

Using a function as one of the arguments in a formula that uses a function is called nesting, and we'll refer to that function as a nested function.

To include text in your functions and formulas, surround the text with double quotes (""). The quotes tell Excel it's dealing with text, and by text, we mean any character, including numbers, …

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Create a simple formula to multiply and divide in an Excel spreadsheet. You can multiply two or more numbers in one cell or multiply and divide numbers using cell references.