Forum Discussion
Solved
Finding the most frequently occurring values in a data set
Hello, I have a data set of Zip codes, and need to find which are the most frequently occurring zips in the set. Could someone help me figure this out? Thanks!
Let's say the ZIP codes are in A2:A100.
If the ZIP codes are numbers such as 20500, you can use
=MODE(A2:A100)
to return the most frequently occurring ZIP code.
If they are text values, such as SW1A 1AA, you can use the following array formula, confirmed with Ctrl+Shift+Enter:
=INDEX(A2:A100,MODE(MATCH(A2:A100,A2:A100,0)))
Let's say the ZIP codes are in A2:A100.
If the ZIP codes are numbers such as 20500, you can use
=MODE(A2:A100)
to return the most frequently occurring ZIP code.
If they are text values, such as SW1A 1AA, you can use the following array formula, confirmed with Ctrl+Shift+Enter:
=INDEX(A2:A100,MODE(MATCH(A2:A100,A2:A100,0)))