Some back ground. I am compiling stats for my favorite racetrack and have
already started on the project. I have a worksheet for every year, 57 of
them; which totals the wins, Fast qualiferiers and pre-lim wins for that
year. I have a worksheet for every class (such as late model, hobby stock,
super mods) that has run in those 57 years, also totaling wins, FQ and
pre-lims. Then I have a worksheet for TOTAL wins, FQ and pre-lims (as a
driver may have competed in more than 1 class in his career. I have them
working as far as compiling all the stats, the issue is with duplicating
drivers. What I currently do after inputing a years stats, say 1970. I copy
the drivers for wins in the late model class and add them to the late model
win sheet, but some are duplocated as they had one years previous. I do the
same thing copying those from the Late Model class to the Total sheet. Again
MANY are duplicated. Thus after every year I need to go back and delete the
duplicated drivers and is very tim consuming. My question is. Is there some
sort of formula that will recognicze a "new" driver and add him to the list.
I'll admit my excel experience is limited,so i learn in this fly. My workbook
with only 6 years of date is already 3mb. You can see an early version at
this link,
http://www.modernofficeinteriors.com/berlinhistory.html
I'm open to any suggestions someone might have to make this less tim
consuming.
Also, i'm willing to reward the first who can help with a keyboard tray from
our website. thanks.