I have two lists. I want to get a unique distinct list by comparing the sums of the unique values in list 1 that don't match the sums of the unique values in list 2.
Is that possible?
Sheet1
<colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Is that possible?
Sheet1
B | C | D | |
2 | List 1 | ||
3 | Cat | 10 | |
4 | Cat | 10 | |
5 | Dog | 20 | |
6 | Dog | 10 | |
7 | Dog | 10 | |
8 | House | 5 | |
9 | |||
10 | List 2 | ||
11 | Cat | 10 | |
12 | Cat | 10 | |
13 | Dog | 10 | |
14 | Dog | 10 | |
15 | |||
16 | |||
17 | Answer is Dog and House. |
<colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4