| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I have excel tell me what string appears most in a column?
I have a column of alpha numeric strings and I want excel to be able to find
which strings appear most frequently. The column is several hundred cells/ rows long and each cell contains as many as 15 or so strings. Is there a way to do this as an easily repeatable process in excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I have excel tell me what string appears most in a column?
On Thu, 26 Jan 2006 11:25:02 -0800, btsray
wrote: I have a column of alpha numeric strings and I want excel to be able to find which strings appear most frequently. The column is several hundred cells/ rows long and each cell contains as many as 15 or so strings. Is there a way to do this as an easily repeatable process in excel? Can you give a short example of the actual data and your expected output? --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number times text appears in string | Excel Discussion (Misc queries) | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) | |||
| Zero appears at the end of a string of 16 digits. Two zeros after | Excel Discussion (Misc queries) | |||
| Counting number of time a character appears in a string | Excel Worksheet Functions | |||
Linear Mode
