Say the names are in column A and the dates are in column B. First sort cols
A & B by A and then by B.

This will put all the names in groups sorted by date. Then in C2 enter:

=IF(AND(A1=A2,ABS(B1-B2)<15),"x","") and copy down
--
Gary''s Student - gsnu200847


"nishkrish" wrote:

i want to run a check if the same name appears twice in fifteen days of
period. should i write a macro or a function if so which function

--
Nisha P