VBA: playing with arrays and dictionaries

[Nelson78]

Hello everybody.

I've a situation as follows:

https://imgur.com/6FS0Fqw

I need to calculate how many different cities (column H) have code 233 (column D) and list aaa (column K)

The desired result is in cell N16 = 2, meaning the 2 records in green (in red the not considered duplicates).

I think I need a dictionary.

Thank's in advance.

 

[RoryA]

Forgot I was testing in 365 Insider - it will need array entering in other versions.

 

[Jaafar Tribak]

Forgot I was testing in 365 Insider - it will need array entering in other versions.

Thank you.