Name appears twice in 15 days
 

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

Name appears twice in 15 days
 

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

Name appears twice in 15 days
 

i have same data column A is Date column B is Name but its a running database
i cannot sort or dont have time to take it to different worksheet and work
like this i want either to write a macro which will automatically check for
name once you type in or write a function.
--
Nisha P


"Gary''s Student" wrote:

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