| Author |
 Topic  |
|
|
Locardas
24 Posts |
 Posted - 02/05/2021 : 08:10:50 AM
|
Operating System: 2018
Hello guys,
i want Origin to go row by row through column F and compare the numbers in it. If the same number appears in the respective column, the values of the corresponding 2nd column R should be summed up. At the end I would like to have something like a table in which for a certain number the sums are summurized.
Best regards,
Locardas
 |
Edited by - Locardas on 02/05/2021 08:11:20 AM |
|
|
snowli
USA
1391 Posts |
Posted - 02/05/2021 : 08:54:03 AM
|
Hello,
U can use either of the following
1. Select column R and choose Statistics: Descriptive statistics: Statistics on Columns.
On Input tab, set Group to be column F. On Quantities tab, make sure Sum is checked. U can uncheck those you don't want, e.g. mean, sd, etc.
Click OK.
The last sheet is created with group info. and sum.
2. Select column R and choose Analysis: Data Manipulation: Reduce by Duplicate X Data. Expand Input node. Click > next to X and change it to F. Set Replace Y with sum. Click > next to Output and choose New Sheet to get a new table.
Thanks, Snow
|
 |
|
|
Locardas
24 Posts |
Posted - 02/05/2021 : 09:28:22 AM
|
quote:
Originally posted by snowli
Hello,
U can use either of the following
1. Select column R and choose Statistics: Descriptive statistics: Statistics on Columns.
On Input tab, set Group to be column F. On Quantities tab, make sure Sum is checked. U can uncheck those you don't want, e.g. mean, sd, etc.
Click OK.
The last sheet is created with group info. and sum.
2. Select column R and choose Analysis: Data Manipulation: Reduce by Duplicate X Data. Expand Input node. Click > next to X and change it to F. Set Replace Y with sum. Click > next to Output and choose New Sheet to get a new table.
Thanks, Snow
Thanks Snow, it worked perfectly ! Is there also the possibility to create a new table. In which the values from F form a column in which all the associated values of R are listed ? |
|
|
|
snowli
USA
1391 Posts |
Posted - 02/05/2021 : 10:03:49 AM
|
You can choose Worksheet: Worksheet Query.
Only check F and R on the left side (columns to extract)
Enter F!=-- as condition.
Note: I am not sure if it works in your version. You may need to select F and move it to Alias table before using F in condition.
For Output
Set Recalculation mode: Auto.
Extract to New Worksheet.
There are also options to highlight those rows, etc. as output
Thanks, Snow
|
|
|
|
Locardas
24 Posts |
Posted - 02/05/2021 : 11:05:34 AM
|
Thats great ! Thank you for your help !!!
Best regards,
Carlo
|
Edited by - Locardas on 02/05/2021 11:05:58 AM |
|
|
| |
Topic |
|
|
|
Sum up Column B if in Column A a certain values ap