Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Using Excel’s conditional formatting to highlight duplicates in a single column is one way to find them quickly, although there’s less motive to delete duplicates in this situation.

Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks. The hardest part is finding it!

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

Add a column to any data set in an Excel spreadsheet and fill it with random numbers generated with RAND () b_y dragging the _RAND formula down the column.

You can multiply in Excel using a few different methods. It's easy to multiply two numbers in Excel, but you can also multiply many different cells and numbers together, or multiply a column of ...

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.