Quote Originally Posted by 21forme View Post
It's not the count I'm looking for. I want to produce a list of the words that appear more than once.
Heck, just do a custom sort and look at the list. In first column list all data as number 1 and put the data list in column 2 Then for the second file list put 2 below number 1 in first column and then the second file of data next to it. Then do a custom sort first by Column B then by Column A. Might look something like this:

1 jim
2 jim
1 mary
1 mary
1 mary
2 mary
2 mary
2 mary
1 mike
2 mike
1 mike3
2 mike3
1 sue5
2 sue5
1 tom
2 tom