You may first use loop vba build your matrix,
then use countif function to get the frequency of each number.

I believe you need write code to get it done.
In this way, it makes no difference between 10X10 or 1000X1000.