Addin subclusters

[vjp2.at]

I have

1 2 3
1 2 4
1 3 4
1 3 6
1 3 7

and I want to get

1 2 3.5
1 3 5.6

the number of cells with the first two indices are
not predictable and I want the average of them

1 2 3 3.5
1 2 3
1 3 4 5,6
1 3 6
1 3 7

might actually be a better result

Much obliged



- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[vjp2.at]

ok, subtotal(1,) .. some kind of pivot without a pivot table..??

In <[email protected]> by (e-mail address removed) on Mon, 01 Oct 2012 17:57:38 we perused:

*+-I have

*+-1 2 3
*+-1 2 4
*+-1 3 4
*+-1 3 6
*+-1 3 7

*+-and I want to get

*+-1 2 3.5
*+-1 3 5.6

*+-the number of cells with the first two indices are
*+-not predictable and I want the average of them

*+-1 2 3 3.5
*+-1 2 3
*+-1 3 4 5,6
*+-1 3 6
*+-1 3 7

*+-might actually be a better result

*+-Much obliged



*+- - = -
*+- Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
*+- http://www.panix.com/~vjp2/vasos.htm
*+- ---{Nothing herein constitutes advice. Everything fully disclaimed.}---
*+- [Homeland Security means private firearms not lazy obstructive guards]
*+- [Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]






- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]