DataQuestioner
Board Regular
- Joined
- Sep 12, 2013
- Messages
- 115
A | B | C | D | |
ORIGINAL TEXT | ORIGINAL COUNT | ALPHABETICAL RESULT | NEW COUNT | |
1 | TEST | 2 | TEST | 4 |
2 | TESTER | 3 | TESTED | 5 |
3 | TESTING | 1 | TESTER | 6 |
4 | TEST | 1 | TESTING | 3 |
5 | TESTED | 4 | ||
6 | TESTED | 1 | ||
7 | TEST | 1 | ||
8 | TESTING | 2 | ||
9 | TESTER | 3 | ||
10 | ||||
11 | COUNT = | 18 | COUNT = | 18 |
<tbody>
</tbody>
Using the sample table above, how do I get the text in Column A1:A9, with its associated counts in Column B1:B9, to be merged into unique occurrences of each word, and listed in alphabetical order in Column C, with their new merged count listed in Column D?
NOTE: Obviously, as a cross check, the Total Count in Cells B11 and D11 must be identical.
Thanks.