Want sort F2 F3 F4 first , merge F2 then count first item show happen counts and belongings date
Second picture show my wanted result
Can VBA do it ?Please help
Raw data below
<tbody>
F1
F2
F3
F4
1
Mary
M
2019/2/2
2
Wang
FM
2019/2/3
3
Mary
M
2019/2/4
4
Chang
M
2019/2/5
5
Mary
M...