Hi
I need help with some formulas in a worksheet which records, over 16 weeks,
all performances of an athlete while highlighting any improvements on their
previous best and awards 1 point,and also collects 2 points for each weeks
attendance. The total of which will be used for trophies and certificates.

Wk1 Wk2 Wk3 Wk4 PB
100m 22.36 22.31 23.28 23.07 22.31
longjump 1.68 1.68 1.85 DNF 1.85
Totals
Improve 0 1 1 0 4
Attend 2 2 2 2 8

The improvement of wk4 only equals an improvement if it was better than
personal best not if it was just an improvement on the previous week.Is this
the best way to explain what I am trying to do or is there somewhere i can
send the worksheet to get formulas added.
--
Little Athletics Volunteer
Promoting Family,Fun and Fitness