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.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

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!

Click on the Data tab. Then, click Remove Duplicates. Select the columns that might have copies in the dialog box and press OK. Excel will eliminate duplicate entries, leaving unique values.