I cant seem to get it to work. Ive attached my worksheet again with the attempted formula. Adherence_Automation_File_6.18.12.xls