****High and Low****

[cward129]

Hello, i am currently creating a running report where new data is added daily. for example... each date of the wk the total number of deliveres are recorded, the next column shows the total actualy delivered that day, next column shows failed deliveries then finaly the percentage deliverd. on a seperate sheet i want to display the highest percentage and the lowest percentage so far for the year. obviously there are blanks because we are only at the start of the year which when i order are showing at the top of my list. When new data is added then i need this to update, eg on the 1st jan it was 98% so on the next sheet it will read 98% as the highest, then on the 2nd jan if 99% is the figure this will replace the previous 98% so on an so fourth. Many thanks and i look forward to you replies, any queries please contact me on [email deleted by mod]. cheers.