Identical characters of a list count

June 19, 2022 / 1 minute of reading

First 5 digits:

=COUNTIF(A:A,LEFT(A1,5)&"*")

enter image description here

Last 5 digits:

=COUNTIF(A:A,RIGHT(A1,5)&"*")

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top