Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two-dimensional frequency question
i have another peculiar question. Say you have the following data:
A C B D B D B E A C B E A E B D B E A C B D and you want to count how many times an "A C" is followed by a "B D," and how many. So, output for the above would be: 1: 1 2: 1 i think the way to do it would be to sum over a frequency, but i can't figure out how to set the bin array the way i need it. the bins would have to start at "A C" and reset after any "A <C" thoughts? maybe a way to do it that way or a better way entirely? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency Question | Excel Worksheet Functions | |||
Transposing from two dimensional to one dimensional | Excel Worksheet Functions | |||
newbie question on multi-dimensional array | New Users to Excel | |||
Frequency Question -- Please Help | Excel Discussion (Misc queries) | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) |