Vocabulary List of 1 Peter

Reply

Shawn Wilhite | Forum Activity | Posted: Thu, Jul 11 2013 7:25 AM

I'm wanting to create a Vocabulary List of 1 Peter but wanting to filter my list to words occurring in the NT 30<.

I'm able to create list for all of 1 Peter, but unable to filter my findings. Any help?

Reply

Graham Criddle | Forum Activity | Replied: Thu, Jul 11 2013 8:06 AM

Hi Shawn - and welcome to the forums

Shawn Wilhite:

I'm wanting to create a Vocabulary List of 1 Peter but wanting to filter my list to words occurring in the NT 30<.

I'm able to create list for all of 1 Peter, but unable to filter my findings. Any help?

One approach:

1. Create a word list for 1 Peter and export to an Excel spreadsheet (using the Print/Export dialog box)
2. Create a word list for the entire New Testament (using Matthew-Revelation) - this may take some time! - and export to another spreadsheet
3. Sort the second spreadsheet by count and then delete rows with more than 30 in the count column
4. You now have a spreadsheet showing those words which occur 30 times or less in the New Testament
5. Now sort both spreadsheets by Lemma
6. Manually scan down the entries in the first spreadsheet checking if they appear in the second one - if they do retain the row, otherwise delete it

(I know that step 6 could be automated using Excel lookups and macros but I'm not an Excel spreadsheet)

Hopefully this will help - although others will probably come up with better ideas

Graham