Power Query: COUNTIFS

JDB79 

Steps could be

- Group table by Number without aggregation (All Rows)

- add custom column to filter each of tables on "B"

- add another custom column to count number of rows in each such table

(above 3 steps could be combined in one in formula bar)

- in resulting table

keep only these columns

expand Count column and land result into the grid

Please check in attached file.

JDB79 

I'm certainly not the most suitable to submit a suggestion to you, but I'll give myself a try :).

Here is a small example .

would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.