After that, you will know how many unique values are in that column. For some of you, you could follow that until the ROWS function. Let's say your column heading is in C1, and the final value is ...