Identical characters of a list count June 19, 2022 June 19, 2022 / 1 minute of reading First 5 digits: =COUNTIF(A:A,LEFT(A1,5)&"*") Last 5 digits: =COUNTIF(A:A,RIGHT(A1,5)&"*") CLICK HERE to find out more related problems solutions.