How to cluster data with Excel

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

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.



Luca wrote:
>
> 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