How to cluster data with Excel

[Luca]

Dear all, excuse me for this maybe "too simple" question..

I am trying to find a way to "cluster" simple data on an excel sheet

Example:
Variable a Variable b Variable c
Case 1 1 0 0
Case 2 0 1 1
Case 3 1 0 0
Case 4 1 1 0
Case 5 0 1 1


The systems recognizes that there are 3 possible clusters:

the first with cases that has Variable a as true,
the second has Variables b and c
the third is "all the rest"

Variable a Variable b Variable c
Case 1 1 0 0
Case 3 1 0 0

Case 2 0 1 1
Case 5 0 1 1

Case 4 1 1 0


The same should work for other integers, not only like this example
0 / 1

Thank you in advance

 

[Dave Peterson]

If the cases that need to be grouped have to match in all the variables, I'd use
an extra column and use a formula like:

=b2&"--"&c2&"--"&d2

Then drag down as far as I needed.

Then I could sort by the data by this column and do data|subtotals (in xl2003
menus) to show the break between groups.