#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
You can just use countifs
=COUNTIFS(A1:A6,E1) Please attached a workbook instead of a picture so we dont have to waste time recreating the data Copy the whole list, paste & remove duplicates, then countifs |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
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 |
Count how many have completed each Training Course within a Date Range | 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 |