Hi everyone,
I've got a spreadsheet with thousands of rows of data. We have duplicated some rows of data to make it easier for another group to read through the file. I need to sum up the totals in column B, but I only want to sum unique values and only the first duplicate row from column A.
<tbody>
</tbody>
As you can see, Column A has 3 duplicates, and in my third column I'm showing how I'd like to count them (only the first occurrance; they'll always be the same value in column B).
I need to sum the values of column B, but only when column A is either unique, or the first in a series of duplicates.
Thanks for the attention
Brandon
I've got a spreadsheet with thousands of rows of data. We have duplicated some rows of data to make it easier for another group to read through the file. I need to sum up the totals in column B, but I only want to sum unique values and only the first duplicate row from column A.
ColA | ColB | Desired Sum |
AA | 2 | 2 |
AA | 2 | |
BB | 3 | 3 |
CC | 2 | 2 |
DD | 5 | 5 |
DD | 5 | |
EE | 1 | 1 |
FF | 4 | 4 |
FF | 4 | |
17 |
<tbody>
</tbody>
As you can see, Column A has 3 duplicates, and in my third column I'm showing how I'd like to count them (only the first occurrance; they'll always be the same value in column B).
I need to sum the values of column B, but only when column A is either unique, or the first in a series of duplicates.
Thanks for the attention
Brandon