Dear All! I thought it will be easy to sum up multiple distinct values among duplicates but when I started to do that I stucked finally. My need is far beyond that is why I need your assistance, please.
The scenario: If a text value is duplicated in a specific range of column A (e.g.), I need to sum all the values of column B (e.g.) that are on the same row as the duplicate entry A and list that value in the row where the "last" (down in the column) duplicate entry is situated each time when a series of duplicates entry appear again.
Example:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">
</code>
<tbody>
</tbody><code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">
</code>As you can see, Column A has sets of multiple valued duplicates and one valued duplicates:
Where in column C?
In addition to the above, I need the formula to write the totals of each changing distinct duplicates in the row of each last unique duplicate number, that is:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> 1 must be placed in C:1;
2 must be placed in C:3
(-)3 must be placed in C:6;
1 must be placed in C:7;
(-)2 must be placed in C:9;
2 must be placed in C:11; and
1 must be placed in C:12.
</code>
I think that's it. Thank you all.
Kind regards, Robin
The scenario: If a text value is duplicated in a specific range of column A (e.g.), I need to sum all the values of column B (e.g.) that are on the same row as the duplicate entry A and list that value in the row where the "last" (down in the column) duplicate entry is situated each time when a series of duplicates entry appear again.
Example:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">
</code>
A:1 Neutral | B:1 0 | C:1 1 |
A:2 Good | B:2 1 | C:2 |
A:3 Good | B:3 1 | C:3 2 |
A:4 Bad | B:4 -1 | C:4 |
A:5 Bad | B:5 -1 | C:5 |
A:6 Bad | B:6 -1 | C:6 -3 |
A:7 Good | B:7 1 | C:7 1 |
A:8 Bad | B:8 -1 | C:8 |
A:9 Bad | B:9 -1 | C:9 -2 |
A:10 Good | B:10 1 | C:10 |
A:11 Good | B:11 1 | C:11 2 |
A:12 Neutral | B:12 0 | C:12 1 |
<tbody>
</tbody>
</code>As you can see, Column A has sets of multiple valued duplicates and one valued duplicates:
- “Good” is duplicated 2 timesby 2 values and 1 time by 1 value;
- “Bad” is duplicated 1 time * by 3 values and 1 time* by 2 values;
- “Neutral” is duplicated 2 times* by 1 value.
Where in column C?
In addition to the above, I need the formula to write the totals of each changing distinct duplicates in the row of each last unique duplicate number, that is:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> 1 must be placed in C:1;
2 must be placed in C:3
(-)3 must be placed in C:6;
1 must be placed in C:7;
(-)2 must be placed in C:9;
2 must be placed in C:11; and
1 must be placed in C:12.
</code>
I think that's it. Thank you all.
Kind regards, Robin