max in a list
 

please help

i have 3 worksheets
1st sheet has all names, dates and an assessment type
2nd sheet is a helper sheet and puts them in month and date order
now in the 3rd sheet is a year planner (jan, feb,mar, etc.) with 3 assessors

now in january say, the assessment "summary" appears 5 times
how can i get it to only have 4 "summary" and move the fifth one to the
month earlier

Also i need help on when an assessor puts his holidays in the first sheet
(there is a space for this say b10 under their name) it will block any
assessments showing up under their name on sheet 3 for that month

thanks in advance