Hello everyone, I am trying to count the number of times individual name appears for each of the quarters. I have explained the desired result on the example below and have attached a excel file for your reference. Would appreciate your help. Thanks.
Name 3Q2019 4Q2019 1Q2020
John 2
Harry 3
Noel 2 1 1
Scott 1 2
3/31/2020 John
12/31/2019 Harry
10/31/2019 Harry
8/31/2019 Noel
3/31/2020 John
12/31/2019 Harry
10/31/2019 Noel
8/31/2019 Scott
3/31/2020 Noel
12/31/2019 Scott
10/31/2019 Scott
8/31/2019 Noel
Bookmarks