Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2020, 12:43 PM
Pluviophile Pluviophile is offline Excel Function To Count All Strings In Range Windows 7 64bit Excel Function To Count All Strings In Range Office 2010 64bit
Novice
Excel Function To Count All Strings In Range
 
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, 15 views)
File Type: jpg Result.jpg (6.0 KB, 15 views)
Reply With Quote
  #2  
Old 09-21-2020, 06:22 PM
Purfleet Purfleet is offline Excel Function To Count All Strings In Range Windows 10 Excel Function To Count All Strings In Range Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
Reply

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
Excel Function To Count All Strings In Range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft