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.

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

Need to find cells with specific text? The COUNTIF formula in Excel has got you covered.

Click "Finish" to close the wizard and your phone number will appear as a series of numbers spread out over several columns.

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.