Count number of duplicate and where they visited?

[#1]

Hi All,

I would like to seek your advise on the script (please paste here as I am using the personal edition). Thank in advance.

I have a very long list will be only showing a subset over here in table 1 and the answer I am looking at is:

           ANSWER

Row Labels	Shop	Leisure	Drink	Play	Fun	Eat	NO of events
A	3			1			4
B		3			1		4
C			3			1	4
D					2		2
E				2			2
F						2	2
G	1						1

Table 1   

Customers	Place of visit
A	Shop
B	Leisure
C	Drink
E	Play
D	Fun
F	Eat
A	Shop
B	Leisure
C	Drink
E	Play
D	Fun
F	Eat
A	Shop
B	Leisure
C	Drink
A	Play
B	Fun
C	Eat
G	Shop

[#2]

I using personal edition. Can you paste the script here. Many thanks.

Sent from Outlook Mobile<https://aka.ms/blhgte>

[sunny_talwar]

Seems to be working for me

I guess the only thing I had to do was to add a 's' at the end of customer

If(Count(Customers) > 1, Count(Customers))

Make sure the case is all right and you are not missing anything