![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel VBA function range.replace | thomas47 | Excel Programming | 7 | 03-25-2019 08:25 AM |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
Function to Count Data | bdavidson22 | Excel | 0 | 12-19-2014 11:48 AM |
![]() |
dmcmillion | Excel | 3 | 10-20-2014 09:59 AM |
Use of MIN and count function together | khokababu | Excel | 0 | 02-22-2012 09:40 AM |