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>
</tbody>
Second picture show my wanted result
Can VBA do it ?Please help
Raw data below
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 | 2019/2/6 |
6 | Wang | FM | 2019/2/7 |
7 | Wang | FM | 2019/2/8 |
8 | Mary | FM | 2019/2/9 |
9 | Wang | FM | 2019/2/10 |
10 | Mary | FM | 2019/2/11 |
11 | Mary | FM | 2019/2/12 |
<tbody>
</tbody>
Last edited by a moderator: