|
本帖最后由 喬治兄 于 2019-12-9 17:13 编辑
Welcome, my friend. The main point is making the spare column (matching column) to adjust each word for sorting and match the the Dictionary sequence. The Dictionary word's sequence is not follow words in excel sequence. So, you got to replace space with none character, and replace any not English character with none, such - , . ' /... you got to delete it. and sorting all columns by the matching column and check the page's no. just by substract the prior one, if the results is not 0 or 1, that means could be error, and than check it, find the reason. if you got the logic and familiar with excel sorting technique and proper replace these none English characters, the making of indexes for the dictionary will be successfully.
This method is suitable for disbursing the words to it's proper pages, which interval is delimited by each page first word. So you don't need the exactly wordslist and also can pick the right page and locate at the ballpark word.
|
|