Hi there,
Can anyone please help me with a formula which will identify duplicate text in column I:I when the date in column B is the same??
The text in colum I are initials of people. I want the formula to flag if we have rostered the same initials/person on the same day on a different course.
Thank you in advance.
Can anyone please help me with a formula which will identify duplicate text in column I:I when the date in column B is the same??
The text in colum I are initials of people. I want the formula to flag if we have rostered the same initials/person on the same day on a different course.
Thank you in advance.