This one has been killing me tonight because whilst trying to put in some formulas to do one job I found some bugs elsewhere.
First of all, I am trying to compile the definitive list of the previous results for all of this year's entrants. I do this by taking the full database and then filtering out those that have not yet entered by comparing ID numbers. This now works in alphabetical order.
Then I tried to cross refer people who are listed with more than one name by identifying the name of the second name alongside the first in the alphabetical list. Whilst doing this I discovered that about 20 walkers had duplicated ID numbers. Also one walker was listed with three different name spellings!
Now I have had problems creating a PDF file of the results so I am not quite there yet.
It sounds like you have too much time on your hands...
ReplyDelete