Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding top 5
I have a sheet of data (text), is there a function that will search the list
and tell me what the string is that occurs most in the list? Can it be used to find the top 5 occurring strings? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding top 5
Hi Brad
With your data in column A, enter in B =COUNTIF(A:A,A1) Copy down as far as required. Column B will have a count of the number of occurrences of the strings use Autofilter to select the counts you want displayed -- Regards Roger Govier "Brad" wrote in message ... I have a sheet of data (text), is there a function that will search the list and tell me what the string is that occurs most in the list? Can it be used to find the top 5 occurring strings? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding top 5
I would add a helper column to the worksheet that has a count of the number
of times a string occurs using countif =countif($A$1"$A$100,A1) A1:A100 is thhe range where all the strings are found. The strings with the largest count occurs the most times. You can use the RANK function to get the 5 top items. "Brad" wrote: I have a sheet of data (text), is there a function that will search the list and tell me what the string is that occurs most in the list? Can it be used to find the top 5 occurring strings? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the first value that is less than zero | Excel Worksheet Functions | |||
Finding Same Row Value | Excel Programming | |||
finding value | Excel Discussion (Misc queries) | |||
Finding a value | Excel Programming | |||
vba..finding first non-zero value in a row | Excel Programming |