Countif for first 5 digits and avoiding the duplicate

Hello Friends

Please find the attached file (Countif for first 5 digits and avoiding the duplicate.xlsx)

In the input cell D2 / D3 if we are inputting the first 5 digits then the formula should count by ignoring the duplicate.

That means the repeated duplicated items are counted as one in light yellow cells by formula.

thanks in advance.