Tuesday, August 26, 2014

yogi_Pull Entities With Maximum Number Of Occurrances in Column D

                      Google Spreadsheet   Post  #1736
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-24-2014
post by Zakir B:
Counting help needed!

I have a bunch of text entries in column D. I wanted to find what the most common entry in that column is, so I used the formula:

This formula is in cell E1, and is working very well to show me the most common entry.

My question, however, is regarding the number of times the most common entry appears. How can I make a cell display the number of times the contents of cell E1 occur in column D?

I'm really stuck and I'd like to learn!