Excel Function To Count All Strings In Range

[Pluviophile]

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.

[Purfleet]

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