Build a functional search system using Excel VBA. You can query using a search box and the results are ranked using tf-idf.
Excel file features a functional search box and ranked results.
Includes:
SEARCH (Sheet 1) - Keyword input box and search results ranked by tf-idf score
POSTINGS (Sheet 2) - Indexed list of word, file name, and tf
DICTIONARY (Sheet 3)- Indexed list of word and df