| T O P I C R E V I E W |
| neuerchief |
Posted - 12/10/2018 : 1:19:30 PM
he there,
does anybody have an idea how to reduce the following list efficiently?
A B C
1 a 9
1 a 5
1 a 2
1 a 4
1 a 8
1 b 5
1 b 8
1 b 6
so I want to reduce the columns to
1 a mean(C1:C5)
1 b mean(C5:C...)
tanks
regards
neuerchief |
| 1 L A T E S T R E P L I E S (Newest First) |
| YimingChen |
Posted - 12/10/2018 : 2:10:56 PM
Hi,
If you want to calculate group mean based on group column B, you can try the following:
1. Highlight Col(B), select from menu Worksheet:Remove/Combine Duplicated Rows..
2. In the dialog, set Merge Duplications by to Average. Set Output Worksheet to <New>, click OK.
Thanks,
James |
|
|
