make sure you use the cell of the first actual value in your range. How To Count Unique Values With A Function If you are more comfortable with Microsoft Excel functions, you can compute these ...

You need to make a new column to mention how many ... you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel. When he is not writing about Microsoft Windows ...