In a simple data set, you can look at the results of the COUNT () function and quickly determine that: Two people, Mike and Susan, have one record each. Two people, John and George, have two records.

Counting cells in Excel using the COUNT function is very easy, so if you want to learn how to do it, read this post to learn all about it.