View Single Post
 
Old 09-21-2020, 12:43 PM
Pluviophile Pluviophile is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2013
Posts: 20
Pluviophile is on a distinguished road
Default Excel Function To Count All Strings In Range

I'm looking for a function that would count all of the different occcurrences of different strings within a range. It would go through an input range, cell by cell and, for each unique value it finds, it would count the number of occurrences of that value in the range.

So, for example, if I were to run it on the range in start.jpg, attached, I would get the result shown in result.jpg, attached.

Thanks in advance.
Attached Images
File Type: jpg Start.jpg (3.2 KB, 17 views)
File Type: jpg Result.jpg (6.0 KB, 17 views)
Reply With Quote