wilg19
11-29-2017, 06:16 PM
Hi, have to find how many instances of a name in one column within a date range from another column that is within 7 days of today.
eg
Jill 30
11/28/2017
Ken 47
11/28/2017
Sally 13
11/28/2017
kari 618
11/28/2017
Colleen 24
11/28/2017
Colleen 24
11/28/2017
in a third column I need to count of how many instance of the name in column 1 that occur within 7 days of today in column 2.
eg
Jill 30
11/28/2017
Ken 47
11/28/2017
Sally 13
11/28/2017
kari 618
11/28/2017
Colleen 24
11/28/2017
Colleen 24
11/28/2017
in a third column I need to count of how many instance of the name in column 1 that occur within 7 days of today in column 2.