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.

If you are unfamiliar with inputting formulas into Microsoft Excel, the much simpler way to get the number of unique values in an Excel column is through a filter.

Were you wondering about how to count unique values in Excel? We've got you covered with our guide that have everything you need to know.

Excel is a powerful tool not only for numbers but also for working with text. Sometimes, you may want to know how many cells in a range contain text — for example, if you are tracking responses, names ...

Sometimes when you’re using Excel, you might have data inputted across multiple columns, and you may wish to combine columns. One of the major perks of using spreadsheet software like Excel is that ...

How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

Learn how to count blank or empty cells in Excel and Google Sheets. Use COUNTBLANK , COUNTIF or SUMPRODUCT function to count blank cells in spreadsheet.