Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
message box appears and appears | Excel Discussion (Misc queries) | |||
Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions |