This is where the INDIRECT function comes in handy. Excel's INDIRECT function turns a text string into a reference. This ...

How To Count Unique Values With A Function If you are more comfortable with Microsoft Excel functions, you can compute these ... things get a little more intricate if your column contains text entries ...

That is why using this function is quite time-consuming. However, if you have only ten or twenty rows, you can use this formula to get your job done. Read: How to count Nonblank Cells in Excel.