Hi Phillip,

Am Thu, 2 Apr 2020 02:36:41 -0700 (PDT) schrieb Phillip Swanepoel:

for example
1 aaa 1
2 bbb 1
3 aaa 1
4 aaa 2
5 bbb 1
6 ccc 1
7 ccc 1
8 ddd 1
9 eee 1
10 aaa 1

what i need is to somehow get

l and m

1 aaa 5
2 bbb 2
3 ccc 2
4 ddd 1

insert headers and format your data as table. Then create a Pivot table.
When you edit the table you only must right click to the Pivot table and
choose "Refresh".
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgetN...vHMEw?e=Th6BV6


Regards
Claus B.
--
Windows10
Office 2016