Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect String Frequency on dynamic entries
Hi -
I'm performing a shopping cart analysis (if customers purchase product A what else do they also purchase?) and have run into a bit of a snag ... I need a procedure that will return the most frequently occurring text string found in a contiguous block of 4784 cells (A1:AT104). There are over 10,000 possible values that could be in these cells, so counting the occurrence of ALL of them wouldn't be that efficient ... Additionally, a significant number of the cells in the target block could contain the value 'end' or '#N/A' -- these values need to be ignored. Ideally, the solution would be scalable (allow users to select larger or smaller range) and also allow for choosing the Most frequent, 2nd most frequent, 3rd most frequent, etc values. So, something like: =UDFname(range,3) would return the 3rd most frequently occurring text string in the specified range. Any ideas of how to do such a thing? The only solutions I could find required either knowing what string value to look for or returning a list of values (sorted one way or another). Thanks for looking! //ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the frequency of a text string | Excel Discussion (Misc queries) | |||
String Frequency | Excel Programming | |||
Frequency of a word string in an excel database | Excel Discussion (Misc queries) | |||
how to Detect paragraph in cell in string? | Excel Programming | |||
frequency of characters within a string | Excel Programming |