Please separate the last digit, and add the quantity in each pattern

Please separate the last digit, and add the quantity in each pattern
https://www.excelforum.com/attachmen...1&d=1531173019

As you already had the procedure to separate digits …
To add, you must at least crystal clear explain the need ! Or maybe there is error in your sample …

Hello, MARCL, PLEASE! 1st step, separate the last digits, 2nd step
In each pattern add the amount of its presence, not adding repetitions
* Objective = to see the presence of the 7 patterns of the final digits
* Repeats do not need to add

Try this:

in I5:

=MOD(A5,10)

in Q5**:

=COUNT(1/FREQUENCY(IFERROR(SEARCH($I5:$O5,Q$4),""),{0,1,2,3,4,5,6,7,8,9}))

**Arrayformula, enter with Ctrl+Shift+Enter.