Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Frequency
Is there a way to count the frequency of cell contents?
Example: A B 1Smith Joe 2Smith Mary 3Jones Fred 4Smith Joe 5Jones Fred I want this: Smith Joe 2 Smith Mary 1 Jones Fred 2 Thanks for any advise. |
#2
|
|||
|
|||
On column B names copy this formula
=countif($a1:$a9999,a1) and fill it down column B Or Use a pivot table to show the count of names "james" wrote in message ... Is there a way to count the frequency of cell contents? Example: A B 1Smith Joe 2Smith Mary 3Jones Fred 4Smith Joe 5Jones Fred I want this: Smith Joe 2 Smith Mary 1 Jones Fred 2 Thanks for any advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |